Search results

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

Everything is working now in my first version, just a form, tables, some queries, and the main report, which replicates the original, so all good. Thanks for your help. Another data question. While testing a couple of the tables I put in dummy values to the first couple of tuples, and have...

Thanks again. All normalised now, and my static data is in place. I want to make one change to my form. I want to include a combo box that is only visible if the value of one of the the data items in the underlying table of another combo box is set to Yes, so I'm thinking I need a macro linked...

I'm back! My form works a treat, many thanks. I'm on data now. As I said at the beginning I'm reconstructing a database with non-normalised tables, but there is a lot of data, and I don't want to have to re-enter it all. Simply stated, my problem is this. A Dandelion eg is a member of the...

One more question before I put this form to bed. One of the data items is a location, say the New Forest. I can pick this up now from the list offered by the combo box, but for any date the likelihood is that all the records will have come from the same location. How can I set the combo box to...

OK. It all works now. Many thanks for getting me through. Watch this space for more problems when I start trying to produce reports!