Search results

I guess there is no easy way to do it. Thanks all

Bump. Anyone have any ideas? I have search all over the web in all kinds of places and can't find a thing. Thanks

Hey all. I have a .mdb that links to about 4 thousand 10k .jpgs. Everything is working fine and the database is only about 4 mb. My problem is that everytime the database imports the picture for it to display on the form a Importing box pops up on the screen for just a fraction of a second...

Put this code in your Forms current event. Change as needed Private Sub Form_Current() ' If the number of records in the subform ' is greater than 5, display the ' horizontal scrollbar. If Me.RecordsetClone.RecordCount > 5 Then Me.ScrollBars = 2 Else...

Thanks. I am currently using the image control but it is the importing box that is driving me crazy. Thanks for the info.

Hi all. My db needs to show a small 8kb picture on the form. This picture will change with each record. There will be about 2000 records. As i have it now the db finds the proper picture which is not stored in the database and displays it. The problem is that i get a Importing box pop up on...

I don't have any problems with this database other than I want to learn to do things correctly. My original goal for this test project was to get it working. Now that it works I want to make it correct if not perfect which I am nowhere near at the moment. I know there are a lot of good...

If I post all of the code will you look at it. There is a lot of code though. Thanks

Bump......

Please help with working code. Access 2002 + 2000 ADO Hey all. I have a sample database that is ADO unbound and unlinked. Could some of you experts please look at the code and let me know how to make it better and faster. The code does work but I know very little about programming and Im...

Thanks Man

I am using the following code which i got from the faq page to add data to my users table. The value is added but I still get the default access not in list message. If MsgBox(Message1 & NL & Message2, vbQuestion + vbYesNo, Title) = vbYes Then Response = acDataErrAdded...

Thanks Pat. That makes a lot of sense So Pat do you always use bound controls? What version of Access do you use?

I don't understand how bound forms would be more efficienct then unbound forms. I am in the process a creating a rather large (for me anyway) database for a lumber company that will have 7 users logged in at once. There will not be a whole lot of traffic so i figured access would handle it. I...

I have a unbound form with unlinked tables ADO. My question is about sql and combo boxes. Which is better Using a table as the source of the table rs.Open ("SELECT * FROM tCustomers) Or using a stored query off of the same table rs.Open ("SELECT * FROM qCustomers) I would assume that using...

I got it working.

Sorry this should be posted in the modules and VBA

Yeah the error handlers are messed up. Im not worried about those for now. I can fix those later. This is just a test application. Did you see my problem of the combobox displaying the wrong data? That is what has been bothering me a whole bunch. Thanks By the way I fixed the problems...

This is a cheesier way to do it but it works. Is the combo box bases off its own query. If so you can make a new form based off of a query or table that has the entries for the combo box. go to the combo box on the previous form and do this Right click on the combo that you want to add a...

Access 2000 ADO I hava attached a folder with 2 databases in it. CustomerDATA.mdb and Customer.mdb. CustomerDATA.mdb has 2 table in it. tCustomers and tUsers tUsers records UserID -- UserName 1 -- Hooks1 2 -- Jim2 3 --...