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...

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...

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...

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...

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...

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...

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...

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...

Today I upgraded my work PC from Access 2000 (which my original database was written with) to Access 2003. Everything seems to work regularly except the following line of code. DoCmd.TransferSpreadsheet acExport, , "tblLANConnections", strBackupPath & "tblLANConnections.xls", True When I...

Is there a way to use the range option to specify an all data type of condition instead of simply selecting an overly large range for a set of data that will never be the same in size? IE instead of A1:G10 in the range field, something to the effect of the dos wildcard *.* Any help would be...

Is there a way to have a variable store data and retain that data, even after access closes? Ive tried what my limited knowledge allowed me to try which was making the variable a public variable in the main module, but that didnt seem to work.. As I write this, im thinking it would be possible...

Yes, its in excel, im lazy :P Data similar to this is imported into the database I am creating for my users. If you notice, in the servername field, some records have no information. Those records imply that the servername above it is the servername in question. Is there any way, via SQL to say...

For some reason I can never size a form to display the way I wish it to in the user mode. During design, I size it down, sometimes I have to overlap parts of the form with the scrollbars to get it to appear the way I want it to, and then a few form loads down the line, the form seems to grow :P...

Im nearly finished creating my first real production database, its pretty exciting! Theres a few things that I need to accomplish to consider it 100% working and im wondering if anyone has any input on the following matters: 1) Users import their data via an excel spreadsheet. Its all done...

Is there a cell range option that basically equates to 'all data in the worksheet that isnt blank'? IE instead of A1:N7, is there something that states "all populated cells:all populated cells"?

Im pretty new to database structure, terms and whatnots. Im developing a database for my organization solely based off of my limited knowledge of coding structures and languages. The question may seem a little novice, and just wanted to preface it with that 8) Delete Queries seem to delete...

Stupid question that im sure will be answered pretty darn quickly incoming 8) The range option on the TransferSpreadsheet action allows you to specify a worksheet and cell range to work with. I got that working just fine, but is there any way to specify to pull all data thats not blank instead...

Looking for something to add data into a single table field real quicklike. Does it exist or do I have to append query for a single field 8) Thanks!

Is there any clear cut way to directly access a cell in a table via code? Ive looked as far as my eye can look to try and find something quick and easy that allows me to cherry pick data out of a table, but ive had no luck. For instance, I have a table named tblSANConnections with a field in...

This being my first post, id like to thank everyone who contributes here.. ive been watching this site for a while, and its been a simply amazing source of knowledge. Now that the sucking up is over, HELP! 8) Im developing a database that is going to take over tracking point to point...