Search results

Thanks for your ideas. Tom, I copy the application.wait into my code and I received a compilation error, "method or data member not found". Do I need to declare the current application as an object? Thanks

All, I found a thread in the forums about a flashing label, however that particular example uses the form timer and I don't want to use a timer. This is what I have; on a combo box after Update event I check for records in a specific table, If we have records I want to have a label flash in...

Thanks, It works!

How do I get a query to group by months in design view. I need to group by month x and then by field2. If not in Query Design view, what is the best way to write a SQL command for something like that. Thanks, Maritza

Thanks all for your answer. Maritza

I have an access 2000 db that is running on a network. The problem is that even thought nobody is running the application the lock file is not being deleted after the application is close, and it can't be deleted. I'm normally at work before the rest of the group in order to run maintenance on...

I created an Access 2000 DB which run perfect in almost all computers, except a group of around 8 computers. The problem is as follows, I have various report selection screens with command buttons that change the values of a query. The value of the query is then assigned to a Public string...

I have the following command that I'm using in Access 2000. cmdInsertInfo.CommandText = "insert into tblMainHistory (DateDeployed, DateDeparted )" & _ "values ('" & IIf(IsNull(rsGetData!DateDeployed = True), Empty, rsGetData!DateDeployed) & _ "','" & IIf(IsNull(rsGetData!DateDeparted =...

I developed an Access 2000 DB which is being use by aprox 40 users. The DB is on a NT network server. This DB has work without problems for around two months an suddently I have 2 users experiencing problems. This is the error that we get: "The expression On Open you entered as the event...

Thanks a lot, I'm going to try it right now.

I need to track who inputted each record in the DB everytime that we add a record. Searching the knowlege base website I founf this function. This function works on a standalone computer, but it doesn't work over the network. Does anybody have a routine that can do that, or can point me in the...

Open Access DB from within another Access DB Smilie, Don't forget to declare your variables. In this case under General Declarions declare Dim strDataPath as string Also, in the path name, if it's over the network, don't use the drive's letter, (ie C:\, D:\), but the drives name instead, and...

Open Access DB from Access It's my understanding (please correct me if I'm mistaken), that the more applications we have open the more memory we are using. We have around 80 employees that may need access to any of the DBs at one particullar point in the day. They also use and keep open all day...

I was tasked to create like a Desktop Station that would allow the users access to all our Access databases without searching all over our network. I can do this really easy by creating links to the databases on a main form, but I don't want to have more than one instance of access open at a...

From your Tool Menu options, Select Options, Select the Advanced Tab. On the right side of that TAB you will see an Option that has "Default Record Locking", select "Edited Record", that should work.

Hi Pat, No, I don't have a timer. I worked with Visual Basic 6.0 for years before having to work with Access, so I use recordsets a lot. The majority of the code is straight Access, with the exception of the way that I established the connections and the way that I set the properties for the...

Thanks for the replies. Unfortunately the properties were not set to Read Only, and the application is a Standalone. The DB was developed using Access 97 and VBA in a Windows NT environment. I currently have both Access versions installed in my computer. Since this DB was developed to be use by...

I recently converted an Access 97 DB into Access 2000. The application runs well, but If I try to modify the forms or reports it gives an error saying that I don't have exclusive rights to the DB, at any changes that I make would not be save. I checked the properties for the DB and Exclusive is...

OutputTo Thanks to both of you for your help. I work around the problem. The document that I wanted to export the data to was a workbook. Once I saved it as a worksheet it worked fine. Can we used a command like OutputTo to export data to a workwook? Keep in mine that I'm require to develop...

No, that was just to show my format. The following is my real code DoCmd.OutputTo acOutputQuery, "qryIFMonthlySum", acFormatXLS, "C:\MyDocuments\Excel\AccessData", True This is a simple DB, but we need to plot the results in a graph. I'm not impress with Access's graphing cap, so I want to...