Search results for query: *

Hi, I've had a look about on here and generally online and can't find what I'm looking for. I want to create a simple course booking system. I've got the following tables (simplified): tblUsers - table of users UserID* Name etc tblSession - table of all sessions SessionID* Date Title etc...

Afternoon all.... I've had a poke around on here but can't quite find the answer I'm looking for. I'd like to be able to show on a form how many days, hours, minutes and seconds there are until 5pm on May 30th? I'd like this to countdown 'live' while the form is open too. Actually the...

Hi, I've got the following table of pay grades and what the hourly rate is for that pay grade: Grade HourlyRate 3 7.674636175 4 7.971413721 5 8.268711019 6 8.564449064 7 8.863305613 8 9.160602911 9 9.538981289 10 9.834719335 11 10.31237006 12 10.78066528 13 11.26299376 14 11.76195426...

Hi, I've had a quick look on here and online but without a great deal of luck. I have a table that has 2 fields AutoID (autonumber) and AppID (number). I want the AppID field in a new record to increment by 1 from the previous AppID when a new record is added. On the form, I already have a...

Hi, I have a very basic table/form that collects evaluations - I want to be able to analyse some basic data I have a lookup field that lists 5 values: Excellent; Good; Ok; Poor; Very Poor. So lets say my table (tblQ) looks like this: AutoID Response ------------------------------- 1...

Hi, I have a table that contains email addresses within client records. I need to be able to extract from the database a string that I can just copy into my 'To' bar in Outlook 07. So for example, say I have the following addresses in my db: someone@somewhere.com dog@cat.com cat@dog.com I...

Hi, I have a database that lists staff in an organisation and what their area of expertise is. I want to be able to query the database using checkboxes on a form. There are currently 6 areas of expertise in the tblExtpertise (eg A -F)so I have a form with 6 unbound checkboxes that each relate...

Hi, I've got a data entry form for applications that has worked normally and perfectly for months. It has an autonumber field (autoid) that obviously increments sequentially in my data table (tbldata). However today, autonumber has started assigning exisitng numbers to new applications thus...

Hi, I know I may be asking a lot here but here goes... I've got a db that contains a clients table tblClients, which just stores basic name and address info of people who use a facility. When they come to the facility, their attendance is recorded by their ClientID being recorded in...

Hi, I have a form (mainmenu) where the user can select a record from a list box, which then opens up another form (Items) showing the relevant information selected on the main menu. When the 'Items' form opens, the 'Mainmenu' form's visible property is set to false to hide it. Once you've...

Hi, I've got a fairly new laptop running Vista Pro. I have had it online before no problem. Now though, I still get the little globe icon saying I'm connected to my wireless network but when I try and go to any websites I just get the standard 'IE cannot connect to his website'. I've run...

I have a spreadsheet that calculates payments. On the worksheet I have 3 columns 'Bid', 'awarded' and 'refused'. At the top of the worksheet there is a cell that calculates the sum total of the payments pending, 'Total Pending'. I want it to add up the 'Bids' in all those rows where there...

I have an Excel file that has a query embedded in it that takes data from an Access db. The problem is that I want to be able to send the xls to somebody else (who has no link to the Access db), and they are just going to get a load of error messages. Is there a way to save the spreadsheet so...

Hi, I have a table that uses Autonumber to generate the ID number (PK) for the table. The data is entered via a form and I have 2 buttons on there: 'Save' and 'Don't Save'. If a user mistakenly enters a record and wants to exit the input form without saving it, they obviously cick on 'Don't...

Hi, I am running an Access database that updates info 28 spreadsheets from a query in the db. These 28 spreadsheets then feed into 1 'master' spreadsheet as a kind of summary. The problem is that I have to go into each one of the 28 spreadsheets and refresh them all individually first in...

Hi, I am running an Access database that updates 28 spreadsheets. These 28 spreahseets then feed into 1 'master' spreadsheet. The problem is that I have to go into each one of the 28 spreadsheets and refresh them all individually first in order for any changes to be shown on the master sheet...

Hi, Is it possible to close a form without saving the information you've entered? I have a database where users enter details when a new grant application is received. If somebody starts entering info then half way through, for whatever reason, they decide they want to discard that info. At...

Hi I posted a similar problem a little while ago (http://www.tek-tips.com/viewthread.cfm?qid=1454559&page=1), whilst you kind people successfully sorted it out then, unfortuantely I can't seem to fix a similar problem. I use a db to record how many people come into a drop-in centre. This code...

Right then. So I've got a table (tbldata) that records Applications we are sent, with the primary key ApplicationID which is an Autonumber. When an application comes in, we give it whatever ID Access gives it when we've entered it on the system. My boss has asked if the Application IDs can...

I want to count how many females are coming to a drop-in centre and I want to know how old they are. The follwing query calculates the ages of all the females who have attended from their dob which is stored in the table 'tblcontacts' along with their gender. We know who attended a drop in...