Search results

I have spreadsheets containing data I want to import to Access. The spreadsheets contain data item values, but I want to import them to a table based on a query, which contains only keys. How can I convert data item values to key values while importing?

I have a form based on a table whose sole function is to edit records in that table. One data item is Yes/No, but when I display it in the form it shows as 0 or 1. I want it to show as Yes or No, or as a little box with or without a tick. How? Secondly, another form, this time creating new...

I am designing a user input form. I need to record the location for the record, and its grid ref. I draw these from a single table, combined they provide a clear unique ID. I want my form to have a combo box, which first displays the location names, and when the user selects a location, I want...

I posted a while ago about my problems with editing records, and I've got past those things. I've now got a query which is a subset of my data, filtered by date and location. The query works fine, and when I open it in datasheet view I can edit it, no problem. My problem is developing a form to...

I'm trying to set up a form for editing records. My data entry form works fine, but now I need to be able to select a record, by name, location and date, and bring it into a form for editing/adding additional data. I'm thinking I need an initial form to select the criteriia to identify the...

I want to create a report which details records collected by date and place. One report for each date/location combination. These records are stored in a table and accessed using a query, to bring in additional information. What I need to do is to get this report to limit what it reports to...

Now I know this is going to sound daft, but I really can't figure it out. I've designed my form based on a table I want to populate, using data brought in from other tables and queries as lookups. This all seems to work. I've now put a button on the form, on click, to add a new record. I...

I am designing a form. The first combo box will identify the item I want to store data about, but there is a list of about 4000 items to choose from. I want to set up the combo box so that when it is clicked or you tab to it you can start to type the first few letters of what you are looking...

I'm designing a form to gather data including two names for each item. The two names are listed in a query, and I want to display the value in the first column to allow the user to select the correct value, then to use the values in both the first and second columns to populate fields in the new...