Search results

Lets say a user clicks an item in a combo box, and then does whatever it is that they need to do with the selected item. Now, theres another combobox that the user needs to work with. Is there any way that I can programatically revert the first combobox back to default state? Im basically...

Good question. Im a noobie with homegrown experience 8) Ill go ahead and look into subforms. Thanks.

I wish to have a loop that saves a record each time the loop iterates. Below is the code that I attempted. After debugging, I was faced with a message stating that I cannot use the SaveRecord command at this time. Is there any other way to attempt what im trying to do here? (Basically allow the...

Thanks for the idea and the link.. I believe this is exactly what I am after... Appreciated..

Lets say that you have a form, using a table as a recordsource, that a user enters data into from a series of blank textboxes. After they enter the first bit of data, they click a button to save the record and go to a new blank record. Next, information that will most likely be used for the...

Well, I tried the me.undo method... It may work.. however its not being called at the right time and I cant figure out how to call it at the right time. When the user clicks the close button on the form, it appears as though the error messages occur before the close event starts. Putting...

Wasnt aware of its existance 8) Ill give it a shot now. Thanks!

I have a data entry form that has a bunch of text boxes bound to a table. Currently, after a user enters their information, they click a button to save the record and certain info that was entered that would likely be used again for the next bit of data entry are auto populated into the text...

As I suspected. Thank you for the information. Seems kind of wierd that there is no microsoft supplied OCX to simply plop a read only .doc into a database control. Oh well!

I had to ask almost this exact question yesterday... the following lines of code, put into the form_load or form_open event should accomplish what you want to do: lstResults.Selected(1) = True The above line highlights the second item in the list. The first item in my list was actually a...

Im looking for a pre made control that displays formatted information for a database update history page. Basically im looking to have the following output: (red text) (black text) XX/XX/XXXX So and so Functionality was implemented Im looking to have multiple lines with a...

Worked brilliantly... thanks again!

Hi guys, quick question. Im trying to programmatically select a listing in a list box, lstResults.Selected(1) = True and then have the listbox's Boundcolumn update to reflect what has been selected. The above snippet of code visually selects the item in the list box just fine... highlights...

Thanks! I didnt know why I didnt think of it that way. Cheers!

Well that explains things... Is there any way to link a table via code easily? The nature of the function that im working with overwrites the table, so technically, for a period of time, the table is deleted, therefore the link is removed for that split second between delete and write. I guess...

Let me explain a little bit further. I am trying to use the following line of code to transfer data out of a table that I have in a backend database. The code is ran from the front end database. DoCmd.TransferSpreadsheet acExport, , "tblLANPDAExport", FileSelected The part I put in bold is...

I recently used the linked table manager on my database and was quite pleased with the results, until now. I have to do an excel export from one of the backend linked tables and im not sure how to do it. Is there a way to tell the transferspreadsheet and transferdatabase commands to look...

Perhaps I can clarify with the attached image. This is all sample data for explanation purposes. I have two tables, the top being my 'main' table. It will have listings with names, and information related to those names. The combination of first, middle and last name is the primary key for the...

Well, unfortunately, an append query would result in a key violation. I need to find a way to either delete before I append or simply overwrite data in the main table. If anyone has any pointers, please send them my way, im 100% stumped.

I have one table, which will contain 4-10 or so records tops. Its structure is identical to another table with many many more records in it. I want to take the table with the small amount of records and basically overwrite data in the other table that matches a field in the small table, without...