I am trying to run the following code in Access 2000. When I do, I get a "Compile Error: Variable Not Defined" and the debug highlights,...
4812
Greg Kane
pgwhacker@...
Feb 6, 2004 4:29 pm
Dear Brainiacs, I scan client letters and contracts and store them as .pdfs. Each client gets his own Windows XP folder, but the names of the files in the ...
I have a secured database. I split it and I have the database with the tables on the server, running novell 6, and the linked database on the user's hard...
I always leave the MDW file on the server. That way, the administrator can manage all user accounts in one place, rather than having to physically jump around...
I'm setting up a Form and I need to add a flag that indicates if a group's service level agreement has been met. Basically, if a document comes in before...
4817
Gill Jewell
gaj@...
Mar 4, 2004 4:52 pm
Dates need # symbol front and back I think. #12:00 pm# mytime ans 12:00 no 01:00 no 17:00 y where ans=ans: IIf([mytime]>#12:00:00#,"y","no") G Gill Jewell ...
Hi, use like if (timevalue(TransInTime) <= timevalue(12:00 PM) And format(CompDate,"yyyy-dd-MM") = format(TransInDate,"yyyy-dd-MM") and dateformat in database...
I have a many-tomany database (about litterature). I have a query (Query1) made up with info from Table A (called "Join") and Table B (called Categories). In...
I have a form with a control titled "Total_1". Let's say the value of "Total_1" is 5. "Total_1" is a field in my table. Now I want to say "If "Total_1" is 5...
Can anybody give me some help with repainting the screen after an occurrence. The results of one control affects the result in another control. However, I...
If I will be very much grateful if somebody can solve my problem which is as follows: Following tables are kept in separate database in a folder called: ...
I'm having a problem with a OLE object. The database is multi-user; one user may embed an image or file in the field. Unfortunately, when another user tries to...
Hi, We are looking for Software consultants in the given discipline to join in NJ, USA based Consultancy Company. Consultant should have at least 2 yrs of IT...
Dear Members, I am facing problem to align justify text in my application. The scenario is that I created a report that has static data as well as it pick some...
I have an sql2000 db that stores user information and pictures in BLOB, I want to connect via access and display the image in a form, how can I accomplish...
ADVERTISEMENT Earn thousands from the comfort of your home by selling household products on the Internet. Commission Based payments – No MLM. Contact: :...
Hello This company really helped me out. I almost lost my home. I am self employed and I was able to refinance. The best interest rates are available, for a...
hey hey, just thought id tell you guys about this free debt consolidation site that reduced my monthly payments by damn near half, no more worries about bills!...
I was really far into debt. Like Most I was in Financial dispair. I could not seem to get ahead no matter how hard I tried. Untill I found this place. ...
Hi folks, Just joined here in the hope that someone can anser the question of whether Lotus Approach Db info can be transerred to Access - either 97 or 2000. ...
I have two tables and need to copy data from one the the other. The first table is [estimatepartslist] and the second is [workorderspartslist]. When setting...
... Build an APPEND query and include the fields from the source table (estimatepartslist) to be copied. If you use the query wizard, it will lead you through...
Hi, Can anyone tell me what it means when "it" says "Reinstall the OLE server to ensure that its registered" This keeps coming up when I try to cut 'n' opaste...
Hi, MS Access Version: XP Database Version: Access 2000 Tables: Linked to an Access 2000 DB I'm not sure if this has anything to do with it but I imported 2...
Hi, MS Access Version: XP Database Version: Access 2000 Tables: Linked to an Access 2000 DB I'm not sure if this has anything to do with it but I imported 2...
