Search results

Someone recently answered my query with regards to uploading data to an access table. The first coloumn is an auto incremented number. Will there be any problems with importing data - when one field is auto increment? Obviously I wont be uploading values for this column - can that be done?

You must have creted databases before which needed to be populated with dada from another source. I have a database with three tables. People Organisations Employment I have two spreadsheets - one with organisations and one with people. Approximately 700 records for each - how will I upload...

I have created my database - I now need to upload data from my old database. I have the old data in an excel spreadsheet and have edited the data so that it matches the coloums in the new database. I have one problem, I can upload all the person data into the person table and I can upload...

I have a form which has a combo box, the dropdown list in this combo box is populated with surname, givename for each contact. When user begins to enter surname the list pulls up the record - user presses enter OR selects value from list and the text boxes on the left are populated with data...

Hi, How do you normally prevent duplicates being inputted into you forms. My Idea is this The input text box doubles up as a dropdownlist of current values held in the database for that field. So when you access the organisation form and go to the first text box as you enter the 'I' for IBM...

Hi All my queries are working apart from the last one - I think I have forgotten how to do do it,can someone please help. On my main menu form I have a query labelled 'Search By Role. I want to have a query input box to appear when I click 'Run' But instead of opening a input box, it opens...

I craeted a startup menu and unchecked all the backend functions - now I cant getinto design view - what should I do?

I have used priamry keys in my tables and these are set to auto numbers on the advise of fellow forumites. One question if at the end of every year I need to upload batches of data to my tables, this would mean I would need to go through each record and manually enter the foreign keys in the...

Can this be done I dont really need the scroll bar in one of my subforms, can I remove it and prevent users from using it?

Hi People, Another question, My database is looking good now, but I have one question, I dont want users to view it as I do, i.e with all the wizards etc, so how do I create an interface which does not allow the user to view the backend?

How do I make the command buttons on my form actually do something, the only one that attempts to work is "DELETE RECORD" the others dont do anything at all

Hi Guys, thanks for all your help so far, I have created my database but I have a problem. My main form has details for the organisation and 2 sub forms for employment and person, Now if I have more than one person at an organistion I complete the main form as normal and then add more then...

Hi, I create a form using a wizard, then I go into my subforms and edit it to look more easy on the eye. I save the form and close it, when I re-open the form it looks fine except that the subform appears as a blank white space with Name Subform in top left corner of the sub form?? Whats going on

I am creating a very simple database, It has 3 tables People Employment Organisation The people table contains: surname given name email - primary key phone number course end year Employment is the linking table it contains: Role start year end year employer email - foreign key same as...