Search results

I see. The help file says I can requery a specific control on a form but how do I requery the whole subform on a tab? Should I place the requery command on the onclick event of the tab itself? thanks! P.S.: sorry, forgot to mention I'm using Access 2000

It works!!! Thanks again, Jack.:D

Hi, I have a main form which contain two tabs. One is "open orders" and another one is "closed orders". Each tab has a subform (frmOpenOrders and frmClosedOrders) and each subform is based on different queries: qryOpenOrders: queries the database for open orders only qryClosedOrders: queries...

Great! I'll try that. thanks a lot. :)

Jack, Could you please be more specific? I get what you are saying but I have no clue on how to implement that.... By the way, how would I requery the form based on the month selected on the combo box if the value from the list is, for example, Jannuary, and the values in my table are...

I have a table with orders (orderID, customer name, $$$, etc.) and a form that shows all fields for easy data entry. I'd like to have a combo-box where the user can select a month (Jan, Feb, Mar, etc.) and the form will show only the records for that month. I think it's possible if I use a...

help? Help? Anyone?

I have a report where I'm grouping values based on week. If I use the formating as "ww", the weeks are shown from 1 to 52 with no problems. However I want to be able to show them in a monthly grouping as well, to get something like: Jan week1: $xxxx week2: $xxxx week3: $xxxx week4: $xxxx week5...

Yes! Northwind has a great set of forms (suppliers and products) that gave me some insight on how to perform what I was looking for. Thanks a lot!

Could you be more specific, Pat? How would you accomplish that with a combo box and a subform? It may be simple but it's something that has not occured to me. Thanks!!

Hi! I've successfully created a form with two listboxes, using Access help, that works the following way: - lstSource has a list of names based on a table - cmdSelect is a button that will copy selected items from lstSource to the other list box - lstDestination is the list box that receives...

OK it seems I've solved the problem... After doing some research on the net on the subject "MS access slow windows nt", I came across what seems to be a fairly common problem, that is running access databases on the network. Going directly to the point: I needed to update my jet database...

Thanks for the advice. I have in my database the "compact on close" option checked. Does this help at all or will only slow the shut-down process?

Avoiding DB corruption - any tips? Hi! I've created an Access 2000 DB with security at the user level and placed the .mdb file on my network. As there will be only 3 or 4 people accessing it at a given time, I thought I didn't need to split it into FE/BE. By reading other posts in this forum...

Hi! I've deployed my Access database (using MS Access 2000) on my network, have setup security and everything is fine. However I noticed that users running Windows NT are having problems... as soon as they log in the database and the startup form I created goes up showing their main menu...

OK, I'll try that too. I'll post my results. thanks!

cpod, you're a genius!!!! :) Moving the second date entry just below the first one solved the problem. Hurrayy!!!! Thank you so much!

Humm... yes, this could work. I think I can manage creating a multi-select list box based on my Rep table (I've seen this somewhere) but how can I get the values selected from the multi-select list box back to my rep-order table?

Yes, Pat. I understand that. In fact, I do have my tables set up that way: Table: Order Fields: OrderID (key), OrderDate, Customer, TotalAmount, Product, ShipDate Table: Rep Fields: RepID (key), RepName, RepTitle, RepRegion Table: Rep-Order Fields: OrderID (key) , RepID (key) One order may...

Did that. Still not working... what could this possibly be?! I'm almost at the point of deleting and creating the report from scratch. :(