Don I'm very confused. Your append query is trying to take data from TEMPtblLocations and append it to TEMPtblLocations I've never seen such a query before and...
Use a second hidden text box that has the field of the table as the control source. Use the one with the IIf statement to populate the hidden one. Regards, ...
It is possible to take data from a table and append it back to itself. But if you aren't returning any records when it's a select query, then there isn't...
Don, Let's say your criteria was right, it still wouldn't append anything because you have the field 'Julian Date' as a required field in your table and you ...
Hi everyone, I have this code from "Running Access 97" book by John Viescas. It is located in OnClick event for a Search button. It collects info from a ...
Often locations of objects in design can be tough. Use the small ID drop down box on the upper left of your design screen. If you used the line tool to make...
Hi there. It's a simple thing really and one which gets those of us who use the dd/mm/yy date format - although Access can *display* dates in a variety of ...
That's not quite true. While you can pass dates as dd/mm/yy, Access by default reads it as mm/dd/yyyy. If you aren't passing the date values in the numeric...
Dan, It looks like a library reference may be missing that has that defined as a constant. From the prefix, I would guess it is the MS Office library. Check...
If it is ensured that the date expression is non-ambiguous (i.e. no scope for confusion between day, month and year), it will always get interpreted correctly,...
I completely agree with A.D. In training young archaeologist I insist that the date be entered in a totally unambiguous format. It really bothers me when...
Access 2000 doesn't come with the File picker object library. You can use an API call to the system dialog box if you want to. It will require making some...
Hello, I'm looking to see if anyone has experience building a database that tracks service and maintenance calls. I'm having trouble building mine in regards...
I don't know where to post this question, but any help is appreciated I have a database that keeps track of all customers and invoices. Is there any way to...
Hi Neil, Thanks for the advice. I looked over the DB (which I inherited) a little better since my connections where down and dicovered the table could be...
Hi Neil, Thanks for the advice. I looked over the DB (which I inherited) a little better since my connections where down and dicovered the table could be...
Greetings Everyone, I am still unable to get my query to do what I need it to do, so I am throwing my problem out to all of you. Here is what I need... I am...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Feb 2, 2004 10:36 pm
12056
After thinking about my post I realized I should give you a little bit more info on what I need to do. I need to print a report showing what to pull from what...
Beth, Well I have tried all that I can figure out to do from your instructions. first of all, I was trying to zoom and find the line, even before you suggested...
Well I finally found that little bugger!! That 's the good news, I deleted it and clicked on the report view, but I got a message "The selection width is...
Hello Susan, You still use winzip by opening your Windows Explorer and zipping the database. If you would like to upload it to the files section, I'll be ...
Once your line was on the page, and too long, it increased the page width. You'll need to make the report width smaller before it will quit displaying the...
OK, So are you saying that when the line was there the program thought I wanted it to give me the almost blank page but with the line on it? When I removed it,...
Can somebody help me. I have to use a top values query that includes a calculated field for a victory margin of a superbowl database. I have to use the abs...
Hi Susan You are right about the line. It's the / on the toolbar. By default it is one inch long. The easiest way to set the length is to click on the line ...
Yup... That's what I am saying... "when the line was there the program thought you wanted it to give you the almost blank page but with the line on it. When...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
