Search results for query: *

try: DoCmd.SetWarnings False. Set it to true to display them again.

thanks for that, but unfortunately it still didn't work. I need a way to only make it requery after the data has actually updated. Even though I requery it after it has gone thru the loop, it seems like it is still updating when I requery it.

I have the following code which uses the update statement to update data in a table for the items which are selected in a listbox on a form, which works fine. My problem is after the data is updated, how do I refresh the listbox? I tried putting me![listbox].Requery after the loop, but it doesnt...

I have a textbox on a form and I want to set it's default value to be the date of the coming Friday e.g. suppose today is Thursday 10th of March, I want the default value of the textbox to read Friday 11th March. I am sure I have done this before, but I can't remember how. I do remember it was...

I have a computer running ME that I want added to a domain on my LAN. At the moment it is logged on to the network, I set the client to log on to a NT domain and enter the domain name (ENGINEERING), but when I browse the network, the ME computer appears under a workgroup (called WORKGROUP), not...

set the read-only attribute of the data MDB file before you copy it to a CD. If its not set, Access thinks the tables are updateable even when they are stored on write protected disk or CD.

I have a mainform which has a couple of textboxes that are used to get data which builds a string. The string forms the criteria for a filter to be applied to a subform using the applyfilter method. The problem is how do I get it to apply to the subform? I tried to use the selectobject method to...

you could have references to libraries which were on the W98 computer, but missing on the W95 computer. Go in the design view of any module and look in Tools -> References, maybe there is a tick next to a library which says "MISSING:some_library_name". If so, try removing the reference.

does anyone know where the messages, personal folders etc are stored, is it on the client machine or the server, and is there a way of changing the location where they are stored?

I have a query where one of the fields criteria is set to the value a user selets from a listbox on a form, so the criteria is Forms![FormName]![ControlName].Value, which is fine when only one value will be selected. Now I have to change the form so the listbox can have multiple values selected...