Search results

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...

Greetings, I have been trying to find a solution to this very problem for over 3 years for a Quote database, and I have not been able to find one. However, I early on found a work-around that works quite well- having the user type in the item number themselves when the order is being entered...

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...

Try using a "Count" variable.

Hi, I need more info, what do you mean by the top 50, what are the fields involved?

Thanks Neil, That was the problem. I had that form closeing a little further downstream. Thanks for your help.:)

Hi Neil, That button runs a macro that (1) Deletes a temp table, (2) Recreates the temp table with current info, and (3) Opens a form based on the temp table. I have another form that is basically the same set up (info in the body and button in the footer) using checkboxes that works fine...

Is there any way to sort accending but with blanks on the bottom?

Thanks Jack, my problem may not be fixable. I'm writing a db for grocery shopping. Most items are in numbered isles but some are in Dairy or Meat or Produce. Thanks for your help and any new ideas you have to fix my problem.:)

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, I think you need to look to the Microsoft Knowledge base for help with this problem. I know that Windows 2000 has caused problems with alot of programs. Even Microsoft programs. And I think the error you are receiving is a Windows one and not an Access one. I think if you look for this...

If you are trying to use too many tables at once to query, that could cause a problem. You should try to break it down to different queries. Use one query to get some info out of a couple of tables, and another to get some info out of the other tables. Then take those queries,and try to get...

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...

Thanks Tim, You are right about the button being on the main form and the options check box of the subform. I will try your idea. Thanks again! DAK

Just a thought, but have you tried using the Sorting and Grouping option found in the View toolbar for your data on the report? DAK