Search results

How do you set up Autokey Macros? I know there is a way, but I can't make it work. He wants ctl+d to be todays date, I know the code, I followed the helps, but it still won't work. Any help is very appreciated, My boss is So on my case! Thanks all for any help. I haven't had to program...

Greetings, here is the situation: A business network group has a requirement that members meet one-on-one on a random rotation to build stronger ties, therefore more opportunity for referrals. So, I am trying to create a database that will take the members names and then randomly match them...

Greetings All. Here is what I dream of: I have a potential client that has at least 100 reports they need to access. I was thinking..what if I put the reports in a database on the server. Then when someone on the network called for certain reports, the reports could be copied down to the...

Greetings All, I have a feeling that my problem is easy, but I have been in a panic over this project, that I cant think too straight anymore (I think I need a vacation!) I have a simple form for tracking employee activity, such as rehire, death, orig hire, exc. This works find, except they...

Greetings All, I have a potential client that is using an access database, tons of word templates and excel spreadsheets. They are having problems with word merge. The way it works now, they have to do one document at a time, constantly switching back and forth. I would like to put all of...

Greetings, I have been working on a database for a school system. This database tracks the teacher absences and the reason for the absences; ex: Sick day, Family Illness, Jury duty. I am trying not to hard code the type of absences into the subreport, but allow it to change as reasons are...

HI, I need big time help: I have several tables that need to be exported, fixed width, into ONE text file. The big problem is that each table has different specifications that must be used, so I can't query everything and send it out once. Big Question: Is there a way to combine the transfer...

Hi all, I have to export data from various access tables out as .dat files for importing into ADP Benefit Services system. I can get the records out table by table and then manually unite them in the .dat file, but that is not how they want the data. I need to get the records out of all...

Hi, This is the second time I have come against this problem. I know how to make it work, but there has to be a more logical way: Simple Invoice database. Three table: Customer, Invoices, Payments. To create the Invoice report I: sum(Invoices) - sum(Payments) to find money owed. I do the...

Hi, Is there any way to turn off the Access Screen that is displayed when you open up an Access databasa? Thanks for any ideas DAKCG

Is there a way to open up Access database without the screen that says Access2000? Thanks DAKCG

Hi, I have a simple Invoice database that I have converted to open in runtime. When creating invoices, I run an append query, then a form for printing options opens up. Except in the runtime the form doesn't open, instead warnings regarding the append query appear, even though I have turned...

Hi, I have a database for creating invoices. After the invoices are created, they are displayed on the screen. Is there a way to program it so that only the visible report will print. I tried to do that using a form and code to print 1, and it did, it printed 1 page of the button! So I need...

Hi, I have recently put on the Access cap again after a year away, and Boy, how fast you forget! Anyway, I am in the last steps of a simple database, and I am caught on what seems like a simple thing: It is a simple Invoice/Payment DB. What I need is the last 3 payments of the Customer to...

Greetings, I recently upgraded my computer to Windows XP from Windows 2000. I have Access 2000, and had no problem getting code to run in Win 2000, but I am have alot of problems with XP! The codes on my older forms work just fine, but every time I try to create a new form, either I can't get...

I'm trying to use two controls in the Header and have a continuous form show up in the Details based on the selections in the header. The DB has to do with multiple gas and electric meters in different units in a property. In the Header I have drop down boxes specifying Unit and Meter type...

I have set the sort and grouping to accending and now I get 1, 13, 18, 2, 3. I want 1,2,3,13,18. Any help

Hi all, I have a form with the control buttons in the footer. My problem is when the user fills in the last box that they want to and then hit the control button in the footer that last bit of information does not come thru. I've tried a DoCmdRunCommand acCmdSaveRecord but it doesn't seem to be...

Greetings, I have a database that opens with a reminder screen that runs a query to bring up any reminders that are equal or before the current date. That part works perfectly, the problem is, I cannot figure out how to get the form to Not open when there is no reminders that meet the...

Hi, Is there a way to hide a checkbox on a form once it has been activated? ex: The user checks a checkbox on frmChooseOption, the corresponding form opens, and once the user clicks continue, the frmChooseOption opens up again, without any checkboxes that had already been checked. I hope this...