I create from and copy SQL statement form Query Design to command click event procedure But it is not work, If I Run from Query it works. I don't understand...

When printing on HP 5500ps printer, occasionally page does not print as shown on screen. Items on left side are moved over a few inches and text boxes...

1. How come one can not make a good query based on more than 2 tables so as to allow a person to make a decent form that contains all necessary fields? 2. The...

My update isn't updating the table. Why? Code is: strSQL = "Update AVAILABILITY " & _ "Set AVAILABILITY. = " & varNewID & _ " WHERE AVAILABILITY.BookingDate=...

I used a template to create a database in Access 2007 and imported the data. I have a subform in the main form and the notes I can import and they work but...

I am trying to use the time and billing template in Access to create a simple billing application. But the invoice preview grand total Keeps showing as #error...

I copy code from query, It work normal. INSERT INTO A SELECT TX.* FROM TX WHERE ((("maintid")=!.)); After that I try to copy code to form on command_click...

Hello, All! I need help!!! I divide my base and have an error in this (befor dividing my program works exellent): Dim Db As Database, t As Recordset ...

I have a split database that I've been working on a while with just 3 users while in the test mode. I rolled it out to the whole company this week and I've...

I have a couple of issues. The first is I need to know the record count of a record set. I looked in the help and found this "RecordCount Property Returns...

Hyperlinks work perfectly everywhere other than Outlook SBE 2003. ie: original email box-While in Outlook, Locate Link Browser box pops up when clicking any...

My code From Cmdclick event is Me.Plan.LinkMasterfields Me!Plansub.form.Plan.LinkChildfields Where Plan is control name on Main and Subform (Yes/No...

I'm trying to convert a flat CSV database into a normalised Access database. I've imported it into Access and want to replace the field 'Categories' with a...

I installed Access 2003 yesterday as an upgrade to Office 203 standard and am trying to import from and link to an Excel 2003 spreadsheet. However Access 2003...

Actually Iam new to this. Till now I had no problems. Today, on taking print outs, the matter is printed on the corner of the page. The font is small as well....

Having just started this course , i am stuck with my table, when i enter the date in short it changes to another date altogether, eg. 19/11/07 changes to...

I have been working on a new database for some time. After taking a break for two days, I resumed entering data in my inventory index. For some reason, the...

I have an Access data base that is shared by computers using Access 2000, 2002, and XP 2003. I want to print the Relationship flow chart but no matter which...

I have made a form and put fields into it, but for some reason it will only print if I put the fields into the header section, which I don't want to do. I...

What gives with Access? I spent a ton of time studying how to use it, and now I find that few people (even SMALL businesses) are using it. Why is that? I...