Search results

Hi, I'm still working on a single project (and have been for the past year?) which is starting to annoy me greatly. Basically; I have a recordset setup to update the data in a table after an append query copies the record accross to an archive, but setting the recordset to update the right...

Hi, I'm developing a form, and when the user enters a text box, a reference code start is automaticaly entered of CMP-BCA so the user can enter four digits, however I want the Carrat/Cursor/Text Pointer to move to the end of this, i.e. after the A Is there any way to do this?

Hi There, I'm developing a bookings system for work. The outcome is a report of the booking confirmation. I've found software that will "print" to Adobe PDF format however, is there any way to attach the specific confirmation report to a standard email and then send to the customers supplied...

My queries have to return the count of the number in each selection. e.g. Was the venue appropriate? Aggree - 350 Disagree - 21 Dont Know - 49 The way I designed my table is to have each questionnaire in one row. Probably not the best planning but I wasnt really paying much attention while...

ok, i'll have a go ! Thanks!

I really dont want to have to re-enter 400 odd survey forms if possible. I'm not all familiar with sub-reports etc. I'll have a hunt aroun in access help for some info.

I've got a database with ~420 records containing multiple choice answers from a surevey we conducted over the christmas time. I've really just only got round to compiling the data so I can hand it in to head office. So basically what i've done is created a query for each of the questions (7 in...

Thanks very much :D

Hi, I have an arrival date and a departure date and I need to work out if the current date is within the two dates. It's a criteria for one of my fields on the query I'm using as the backbone for a list box. Any help greatly appreciated :D Thanks, Adzi

just bumping to see if anyone can help

Hi, Basically i'm in the process of creating an bookings system for where I work and I'm having a little trouble. I'm not new to VB, but then again I'm by far, no means and expert. So a little help would be really appreciated. When a camping reservation is taken, the customers details are...

Hi, I need a little help with my Query design. I have an Arrival Date and a Departure Date for campers checking in on a campsite. I need to produce a report for the warden to have to check who's on site. So far, the best way I though was using a new field in the query for "On Site" (which...

Hi there, Im working hard on this database for work, but i've run aground on this problem. Im not even sure if its possible... A permit number is typed into a search box. The comand button takes the search term (the permit number) and locates the record. A vbYesNo msgbox confirms the checkout...

Thanks for the help! Worked like a dream!

Hi there, I have a database that i'm looking to password protect with a user login form. The users are all on a combo box which is being gathered from a table. The table also contains the passwords. A query fetches the username and password from the table by the criteria set to the combo box...

I have a table named tblProduct, I have a table names tblProductSpec, tblProduct contains basic info, tblProductSpec contains infomation linked with outer tables. What I need to is have the product ID's duplicated in tblProductSpec. Is it possible to do this via relationships etc? Any help...

Hi there, I have a search form with a text box (unassigned at the moment). The search I want to conduct, filters the product number by the users search string with the use of * as a wildcard option. I also have a Query with all the product numbers listed, no criteria set. How can I link the the...