Recent content by brocsman

Fantastic. I can understand all of that. No problem with reserved words - I was just making something up to show what I was after. I'm a recorder for biological data records, and I get a lot of input in the form of spreadsheets (if I'm lucky), so it's important for me to be able to append...

Apologies. I should have declared I’m a rank amateur.There may well be something obvious I’m missing. I’m using a hand-me-down database with tables which have not been normalised. I’m trying to develop a replacement. So, let’s say I’m starting from scratch. I’ll make it very simple in the...

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

Got it working, no problem. Many thanks.

Thanks - I'll give it a go tomorrow.

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

Sorry for the delay in replying - I've been away. I think I'm using a bound control (shows how much I know). My main data table is normalised, so holds only keys to other tables. I want to display the existing record, eg the name, in text, (ie take the key from the data table and read the name...

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 sorry, I just can't follow that. Can you explain in a bit more detail. Assume I have an existing dataset, and I want to find a single record to edit in my form. The criteria for finding this record are name, date and location, so I'm trying to create a form to gather these details from the...

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

Thanks for the reply. My Combo Box seems to be set up OK. I've attached a macro to the "open form" button, and when I try to step through it I get "true" returned on the match, but it fails to pick up the data records. I tried to change the Bound column, but I got the key, not the data item...

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

Thanks for this. I'll certainly have a look at your stuff. I know the sequential numbering isn't significant, however I would like to deliver a "virgin" copy of the new stuff, just for the sake of appearances. Thanks again for everything.

Thanks - I've solved that problem now