Search results

Here goes nothing... I have a form which the user can specify (or choose) the path to an excel spreadsheet they wish to import. They then click a button and an inputbox appears asking them what they want to call the table. Since the excel spreadsheet is already named I thought it might be a...

Can someone help me please. I am trying to figure out a way to import file names into an access table without having to copy and paste. I have many files (100 +\-). Any help would be appreciated. Thanks.

Hey folks. Can someone help me with this scenario? I have a table that has 1 record per person. There is a field called "Quantity" for each record. Is there a Query or something I can create that will take the value for "Quantity" and list 1 record for each. ex. If the quantity is 5. I...

I have created a report that shows the barcode for a given text value. I can make it work only if the text has no spaces (Ex: YesSir). However, when the barcode is scanned, I need it to display the text with the spaces (Ex: Yes Sir). Can this be done? Thanks in advance!

Hi. I want to create a make table query where 2 of the 6 fields are set to data type number when the table is made. As it stands, the default data type is text. Is this possible??? Thanks in advance.

I know this is probably simple, but I can seem to get it to work right. The user scanns a barcode into a text box. I need a message box to appear if the number of characters in the text box is less then 15 characters (ie. 8888 instead of 888888888888888). Here is my code. I can't see what is...

I was wondering if there was a way to play a short audio file when a certain record is found. Basically I have a form with a text box, the user scanns a barcode into the textbox. If the db finds a corresponding record, I want it to play an audio file. I have this working with a message box...

I have a form with a combo box that lists all the tables that are in a seperate database. I would like the user to be able to choose the table name from the cboBox, click "OK" and have a select query open and show all information pertaining to the selected table. The trick is, as I stated...

I have a form with a subform which the user inputs data for various contracts. On the form I have a cmd button. When this button is clicked, I want an input box to appear asking the user to select a table. Now for the funky stuff. I want the imput box to show a combo box instead of a text box. I...

I looked throught the forum before posting, but couldn't find much help. I created labels that when the mouse is passed of them, their font size and color change. However, they stay that way after the mouse pointer is moved off. How do I make them change back to normal after the mouse moves off...

Text box lookup I am trying to make a form with only 1 text box. When the user scans a value into the textbox, the value is compaired to values that I have imported into a table. If "it" finds a like value in the table, it displays a message box stating it found a match. If it doesn't find a...

I created a form that allows the user to add information to the appriopriate tables. Long story short, I want to create a command button that runs a make table query, however, I need it to make a different table with a different name everytime it is pushed. The questions are: 1- Is there a way...