Search results for query: *

Good Morning/Afternoon, Does anyone know how I can use the attachment feature, within a form in Access? I would like to give users a command button (similar to the paper clip in word) that would allow users the ability to attach documents ( such as word, excel etc.) to a form within Access...

Greetings, How can I use @iserror with @dbcolumn? Thanks for your help! ~Clark

HI, I'm using Access 97 and I want to trap errors (any standard error message) and write those error messages to a file (.ext or notepad in a specific shared drive). This would help me track and record the number of errors that occur in our business enviornment. In addition, read errors that...

Hello folks, Does anyone have software that can automatically backup files on a daily basis? Besides using the scheduler, there is a neat and most importantly free application that does exist, but I've lost the internet address. Thanks, Clark ~Clark

Hello, Just as my subject stated, I am in the process of generating reports on Access 97 and I need to have the word "Confidential" stamped on any and all reports that are printed. Does anyone know of a program or code that can enable me to have this "confidential" stamp on...

Hello, Does anyone know of a easy and simple method with creating a program that will capture errors and store them in a file? (either word, notepad, etc.) Currently my group is using Access 97... Thanks for your help, Clark ~Clark

Hello all, I'm a frustrated Access application developer and I'm now in the process of upgrading to a new, more powerful system. I currently have about 80,000 records with queries, forms, reports, etc. What are my options for upgrading to a new system, which can hold more volume and be more...

I have a combo box (cbomodel) that stores values of model names. When I toggle in between forms, I want the combo box to remember the last value that was selected, in order to maintain consistency with my users. So far I've used: If statement... strmodelold = me.cbomodelname else...

Hello, Basically, I have a form (frmTest) that has a combo box with model names. If I select for example model A from the combo box, then push a command button to view another form, when I return back to my original form (frmtest), I would like the same model A to be displayed, so the user wont...

Hello, I have an Access database in which upon logging in I have a pic (jpeg)displayed, this pic also changes to a new pic upon a user selecting a different model/picture. This pic is an OLE object that is converted from photo to picture to help reduce size of database. Is there an easier...

Hello, I have an Access database in which upon logging in I have a pic (jpeg)displayed, this pic also changes to a new pic upon a user selecting a different model. This pic is an OLE object that is converted from photo to picture to help reduce size of database. I have tried several different...

Has anyone experienced or seen #Errors when dealing with records in Access? I have a network of users (105) on Access 97 where they constantly update, delete, run queries etc. Recently I've experienced errors from time to time, which doesnt allow me to compact or repair, so I have to copy and...

How can I use HTML (or any web related page) without using a server? I'll try to explain better.... My IS department wont allow an intranet yet, maybe 3-5 years down the line. So I was thinking of a local development, where users (about 100) can access the web and all its data (which also...

Hello, I 'm in the process of creating a webpage, but I want to use data from Access tables. Does anyone have any knowledge of how the two intergrate? Also is it possible to use HTML without a Network? My IS department wont give the necessary space to put this on the network, so I cant...

How do you use email gifs with Lotus Notes?....I'm trying to attached a gif attachment (characters that move) via using Lotus Notes, but cant seem to figure it out. On the website of the gifs, all I was told to do was right click, save, and thats it. Any help would be appreciated. Thanks, Clark

Hello, I had a problem with an earlier post that I couldnt get resolved....anyway. I'm toggling between two databases on my mainform, I have a text box that I double click and it opens a subform, where users can read comments. I want the users to able to update comments (using...

FancyP, FYI, now TDFname is displaying 'tblCRFMaster' after I debug. But I'm still getting the error message.....seems to be getting closer to solving this. Thanks, Clark

I have a form that I'm using in my current database, called form 1. I want to add a command button on form 1 that will retrieve and open form 2, which is located in another database. Any suggestions? Both of the forms are exactly alike, but I've archived alot of records from form1 to form2...

Hello All, Question for anyone out there. I have 5 tables in my database. One of the tables is titled "Whole Number". The Whole Number table is formatted as such: 60650SOX A001H1. The Whole Number could also come in groups and look like this A002, A003, A004, even A0011, A0012 etc. I...

Hello folks, I'm managing a very large database that contains thousands of records. I heard there is a way to automatically archive data; by using a macro or by creating an append or delete query? I basically want to archive any data that isnt being used. Such as old records from 4 years, but...