Search results

Ok. Still struggling. I'm trying to set up the form to log new users and their qualifications. I have a main table with UserID which references the Qual table which lists the userID's and the qualification. The qualifications are selected from a listbox control which gets it's values from the...

Thanks. Created a qualifications table and it's working.

thanks. Just to clarify I have users listed below and want to return all user details for the who have qualifications of Msc or BA. Would this work then? UserId, Qualification 1, BA 1, Msc 1, PHd 2, Ba 2, Bsc 3, Phd 3, Msc Would it return 4 records or 3?

Thanks Dave. But what happens if user1 has Msc and user2 has Msc and BA. If i do a search for Msc and BA wont it return 3 records?

Thanks for you responses. I will need to be able to search on qualification and return the users with that qualification. Eg. a form where you can select to return all users with Msc. But also be able to return all users with Msc and Bsc etc. There are a total of 18 different qualifications...

I have a table with 200 users and need to record their qualifications, some will have more than 1 qualification. Should I make them individual fields eg Field - BA, MSc etc or just have Qualification1, Qualification2, Qualification3, Qualification4 and look up to another table? I will need to...

It's ok, I've got it to work. Is there a way to get it to run before closing the form? There is a macro that runs on close which throws up an error saying that 'you cant save this record at this time' obviously as the date field is missing.

if i set the status to Won but dont enter a date, I can still exit the form.

OK. didnt know that. This is what I've got but it's not working. Private Sub Form_BeforeUpdate(Cancel As Integer) If ((Me.Cmb_ProposalStatus = "WON" Or Me.Cmb_ProposalStatus = "Lost") And _ Len(Me.DateProjectClosed & vbNullString) = 0) Then MsgBox "You need to enter the Date...

Thanks. Just to confirm, is the ME.control the form name or the table name? The form is Edit Records.

I want make a date control compulsory if a value is selected from a combo list on the same form. I have Combo List, status, which can be 25%, 50%, 75%, WON or Lost. If the value is WON or LOST I want the date control, Date Project Closed, to be compulsory. I cant set it to insert today's date...

Yes I will need this value as it will be in most of the reports.

I have a query that takes a value, Proposalvalue, and depending on the currency, loc curr, it calculates the currency. It gets the currency value from the currencies table and appends to TableB eg. proposalvalue currency 50000 1 Currencies id...

Do I have to create a temp table behind the form? Don't know how to store data from form to be retrieve by a query.

I have a blank report and dragged two queries to it so that they are displayed on it. Both queries prompt for a Customer code. How do I get it that I only have to type it in once rather than for each query prompt?

The form is for users to amend sales proposals and only shows active proposals based on the Yes/No. I want them to enter a date when the proposal is won and for that to trigger the Yes/No to be set to No.

Hi, I've only really done the basics with Access so please help. I have a query showing all active (Yes/No) records and have a form based off a table. There is a blank date field which users can modify. I'd like it that if a user modifies a date, it will change the Yes/No value in a tickbox in...

Sorry, am new to this. The database is for inputting sales leads, so there is a form which saves the data to a table. A query then runs to Append that data to the main table and creates a reference number made up of the client name initials and the date (YYMM). EG this month 03/2014 and Smiths...

I need to check if the reference number my query creates, already exists in the table it's being appended to. EG does the query on table A which creates the value '1403ABCDEF01' already exist in table B in the reference field. if it does, change the last 2 digits to 02 and check again until...

Hi all, Just signed up today but been using Access for a while doing what I think is fairly basic stuff. Enjoy using Access as I like being able to create the front end as well as the database and tables.