Search results

I may have time this morning so it may be easier if I knock something up for you and then go through the theory so you can develop it further. Don't hold your breath though as I have to do it in bits when the Boss is not looking :)

OK lets start you off. On a very basic level you will want 2 Tables and 1 form. Table A has 3 fields: 1. Medication (e.g 'salbutimol') 2. Dose (e.g '500') 3. FORM (e.g 'cream') Table B has 5 fields: 1. Date (e.g '01/01/2001') 2. Qty (e.g '10') 3. Medication (e.g. 'salbutimol') 4. Form (e.g...

well you could link the excel sheet to access and then run a query over it, but its just as easy to open up excel and hit F4. Plus how would you determine that it is a telephone number.

If you Google search for "Ms Access Form based on another form" you should get what you need.

Yes query will do it, but a couple of things to think about first. How are you going to determine which invoices to print (have they already been paid in either part of full or are they even due yet) When printing the invoice you will need to print at least 2 copies, one for the client and one...

Are their purely numbers in this field, no special characters or letters? If so you can create a query that will convert the numbers into numeric, look at Val(String) method and create a new table with all the fields plus the new one (Val string thing).

If your form is on that record or its focus is on the list box? If the later then I guess you could use the "On focus" event of the list box and code it to set the colour of the list box control, then change it back to the original colour on the "lost focus" event of the list box?

You need 2 queries. 1. Add State and Customer to your query. Group by state then Customer and output to table (this will give you a table with only one record for each customer in each state) 2. Add State and customer again (from above query table) Group by state then do a count of Customers.

Upload picture to photo website (photobucket etc) and copy and paste the IMG tag and put it in your your thread .

I think you can only do it combo boxes as you said. http://office.microsoft.com/en-us/access-help/basing-one-combo-box-on-another-HA001173058.aspx

Do a search on here for "one combo box based on another"

Havn't really got time to go into it can be complicated but do search on nested IIF statements

Firstly you don't copy and paste into Access. You import the excel sheet into access then format is to whatever you want via query? Or if you are going to be using the same excel sheet in the future then link the table and perform the format when query that linked table.

So you want them to choose from a list and that choice stored into a different table? If so you need to do this on the form. Do a search for combo box.

All I can suggest is restore from your back up and set the database to compact on closing which can prevent corruption in the future. Have a search on the forum first though as their are circumstances where compacting isnt a good idea.

Hi ansenrty yes I did, to be honest I didnt know it was one of the reserved access names. edit* My goodness have they left any names to use :eek:

Thanks vbaInet and ansentry works like a charm!

Doh! Simple when you know how and a good example of the thoery that there are many ways to skin a cat in Access. thanks vbaInet

Of course you are right, and I have read that you dont save calculated feilds. The only reason I am doing this is I have created another form that is searchable by the full name. I guess I should make the search form searched by both Name and Surname together?

I have a form based on a table. Upon saving the newly added records I also want to concatonate two fields on the form and add them to the table into an existing column "Fullname" The two boxes to be concatonated on the form are "Name" and "Lastname" (both bound) I then draged the...