Search results

Hello Sure this is possible and currently trying different things but haven't been able to find any information on what I'm trying to do but not really sure what to search for. I have 2 tables (person / merit) currently the merti table has 4 fields (MeritID, PersonID, Issuer, Type) I'm...

Hello Sorry if this is in the wrong forum. I'm trying to create a function to update and amend records in a table. The update part works and updates existing records with new data but I'm getting an error with the insert part. Might be my SQL, I found it in an example and edited but the...

Hello, I've been using the following code for ages but wanted to change the fields being search because if the search field(NiNo) is blank it wouldn't return any results or jump to that record. Now trying to use the PersonalID field but having problems matching the data types. The code runs...

Hello, I've not been able to locate any information on this and I'm guessing I'll need to do this with some VBA code. I have a table called person with associated fields, name, dob, address, etc and a table called timetable that holds day, start time, end time. I've setup the timetable as a...

Hello, I've creating a database that will only need to store a single record in one of the tables. This table will be linked to another that can store multiple record, like a workplace and employee. There is only one workplace so I only want there to be one record in this table this record...

Hello Please can someone give mesome advice on my DCount statement. I'm using the statement that will count the number of records (people) with an age of 18 who are connect to a certain establishment. The age only needs to be calculated at certain times of the year so it is stored in the table...

Hi, I need to export some data into XML and the data format needs to be YYYY-MM-DD, AC2000 doesn't seem to be able to do it like that closest I can find is in reverse, is it possible to format the date manually in code before exporting it if it can't be stored in that format? Any help is...

Hi I've got a database with 2 main tables from which I need to export the data to XML. I've heard that Access 2003 and later will allow you to export to XML, I'm currently using 2000, is there a way to do it with additional software or would it be best to upgrade access? I thought I might get...

Hi, I have 3 mail merge letters that will be used with a access database/queries they work fine, but when opening the documents they seem to open multiple copies of the database even if it its open already. Just wondering if there is a way to stop this happening, as it is likely to confuse as...

Hi, I have an address field currently formatted 1 Streetname, city, post/zip code it is displayed on a form within a multi-line textbox. I'd like to change the commas to a line return so it will display 1 streetname city postcode I was thinking that a small macro might go through each record...

Hi, have found a lot of info on similar subjects but can't get the syntax right. I have a main form (MainPage_fm) this has about 7 subforms (same level all placed in a tab control) I'm trying to requery a subform from another subform, my guess is I need to refer to the parent form and then to...

hi, i've found some code to copy info from one table to another but need to change it so that it will copy data from multiple tables, certain fields only, to a single table. it is a sort of archive function but won't be used very often so didn't think it was necessary to create 1 to many...

I have a command button on my main form used to load a search form and query which works fine, when you've found the correct record the form will return to the main form and load the correct record in the main form. My problem is trying to load the search form from another form, my guess is that...

Hi, new to the forum hoping someone can help :) I'm half way through a project and want to have 3 queries to search personal information (Surname/DOB/Ref Number) is it possible to select the record in data view from the query search and jump to the record in form view? Would I have to display...