Search results

Cheers JamesM. I did manage to work out almost identical solution yesterday, but many thanks for your help.

HI all, Not sure if this is the right place to post? Hope so. I am currently trying to create an update query (building a SQL String in VBA for a command button click event) to update a variable's value into a table. Basically, there are 2 tables, displayed in 2 sub froms within the same...

I have a fairly complex (at least to me!!) crosstab query I need to create for a work project. The problem is as follows..... I have a table which has a list of houses. Fields included are: Postcode address 1 address 2 address 3 Region Price paid Price bracket date sold This table has multiple...

HI, Be gentle with me....(Noob alert!) Ok, I have recently inherited 2 spreadsheets which were being used to track Jobs/Positions in our company. (i.e. Job title, salary, hours of work etc) and also employees within the organisation. The spreadsheets were linked with Vlookups linking by...

My problem is fairly straight forward (at least it should be!) I have an unbound form used for entering employee's personal details. (Into a table called "tblPersonalDetails" On this form there are unbound fields "Job Title, Division, Department etc" giving a summary of the job the employee is...

Many Thanks Cheers for the prompt responses, will try later on at work. :)

OK, this should be possible but not sure how............. I am using a parameter query which prompts the user for a code to search/select records by. The problem is that the codes are fairly complex and can easily result in typos when entering them in the query dialogue box. In the form...

Ok my problem is this...... I have a form with a field "Property Status" on it. It has 4 possible values - "C - SHELTERED (with warden charge)";"H - SHELTERED (No warden charge)";"J - WHEELCHAIR SHELTERED (With warden charge)";"M - WHEELCHAIR SHELTERED (No warden charge)";"X - DISCONNECTED"...