Search results

Hi there, Can someone please look at my code and help me out help. I am trying to convert over VB code to work with VBA in Access 2003. The code to list all of the available text files in a particular folder is working fine, and they get populated in a listbox called lstFiles, the problem is...

This may be a bigger project than I first thought but what I need to do is import a text file into an existing table. First of all I have created a form with a listbox that I would like to be able to store the text file in. How do I go about loading the text file from my hard drive to the...

Wondering if someone can help me out. Upon click of an Add Card To Collection button I would like to save the values of two textboxes into the fields of a table. First of all the textboxes are filled when a record in a listbox is clicked through the control source property, and I would like to...

Can someone help me out? I have a listbox that is populated with data from a recordset. I would like to know how to display the data on a record in the listbox when clicked into the corresponding textboxes on the botom of the form. I have the following textboxes on the bottom txtCardNo...

My database is coming along quite nicely. Presently when I click a button I have a recordset that hits the database a populates the fields of data on a listbox according to my SQL statement. The data that is displayed is all of the sportscards in a particular set, which I previously chose...

I'm sure my question is very simple but I just can't get it to work. I have two tables: 1. Manufacturer with ManId and ManDesc 2. Set with SetId, SetDesc and ManId Two comboboxes: 1. cboManufacturer which is displaying all of the manufacturers in the table from the rowsource property. 2...

Can someone please help? I have a memo field on a subform, when the form is run the text box appears to be able to be able to hold 8 lines of text before the scroll bar kicks in which is fine. My question is if the user enters just two words on at the beginning of the text box how can the...

Can someone please help? I have a date filed in my db named dateclosed and another filed named outcome (that includes two different scenarios), how can I create a query and a report so that the user can select either outcome at any given time for say the month of October? Would I have to get...

Wondering if someone can help me out again. I have a field ApplicantId in a table Applicant which is a primary key and is displayed on a form frmCandidate. The problem is that the user would like to add a new applicant without having an applicant id for them, all of the other demographics are...

Hey, Can someone help me out. My database is set and working great. I want the user to be able to go in and select an existing candidate from a list of over 100 candidates. All candidates have a unique id named candId. If I were to add a combo box say at the top of my form that would...

I have 4 combo boxes, the first two are filled according to all of the records that are in the Brand and Year tables, the two that I need help with are the Set and Subset combo boxes, How do I code the click event of the set combo box to display just the sets in the set table that are from a...

I have a eight combo boxes that are bound to a look up table. How can I give the user the ability to make a blank selection or change their selection from a valid selection to blank in case their selection was made in error. eg cboStaffing has one of 10 different shifts to choose from in...

Hi there, Was wondering if someone could provide me with code or even sample code on how to validate for a user making multiple combo box selections. I have added 6 additional fields to my Staff table named Staffing1, Staffing2 ...thru Staffing6 which can store one of 4 different shifts of...