Search results

Great it worked a treat! I tweaked the source codes, changed the query design and edited the code for the query (it seemed to prioritise the search). I changed the boxes along the bottom to match the rest of the table, and customised the query viewing window ("QuickSearch") to view the...

I cant remember if the search tool was in 2003 or not, perhaps it is a new thing sorry, Also that link didn't work - told me to tell the administrator.

any form you create - next to the navigation controls near the bottom.

I have noticed in the form, using the search bar at the bottom not only searches all the fields but guesses ahead on what your searching. For example if I typed "ban" it will find "banana street" uder addresses or "ban drugs.com" or something under company... does this make sense? Is it...

Well an IIF is made up of =IIF(Expression, true, false) Switch is just simply =Switch (expression, variable) I find switch particularly useful if many instances are involved, e.g. =switch([sky]="clear","blue",[sky]="night","black") (for example, off the top of my head) It's laid...

I think a switch statement is like an IIF statement without the false end

Hey, could you please attach a sample of this? - I can't seem to get the hang of it. Your methid and my method didn't seem to work. My method kept returning a "the expression is to complicated" error, and the switch function didnt do too well either.

I have 2 tables which I use to filter the main database for various reasons. 1 has a list of around 20 different catagories of business (i.e. cleaners, builders etc...) the 2nd list is a list of sources, i.e. the person who we got the information from by persons initials (e.g. F, N... etc) At...

Worked a treat! Option Compare Database Option Explicit Sub SendMessages(Optional AttachmentPath) Dim MyDB As Database Dim MyRS As Recordset Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim ObjOutlookRecip As Outlook.Recipient Dim objOutlookAttach As...

I found this useful tutorial: http://support.microsoft.com/?id=318881 it's great for sending emails through a database to multiple address with attachments and even importance, however it will only send text which isn't good for marketing purposes or for invoices with the company header on, so...

I did it the other way around, I created the data in Access then exported it to create a raw Excel file with all the settings ready and correct to import them back into Access when data has been entered. I found making sure the fields are the same types the hardest part, so this method sets up...

It was the simple bit and I dont want someone to WRITE the code, I just need guidance, afterall I wont learn anything if someone does all the work for me. 2 parts - counting and adding the extra zero's

Right, it's starting to bug me. I am getting somewhere at last. I have tried a different approach which seems to be working thus far - I just need 2 more things then it will be complete!!!! I have attached a sample I am working on to get this stupid thing working, As you can see it can...

I thoguht I'd scour every source first to find the answer, most things have an answer but not for what I want. For a start, when I use the button wizard, it attaches the information (as an attachment), I need it to be entered into the main email window, as actual text. Secondly, I need it to...

Great!! Thanks!

My Customer Database will be split into 4 catagories: Walkin, Account, Invoice and Quote... but becasue I'm using the same database for the customers they will all share the same ID counts, for example, a customer may purchase something and use an invoice (invoice number1) then an account...

or a number pad at least? whats the best way to create this?

Yes, getting there... i'll tweak it a bit later, thanks!

Aaah! So far so good... but I need it to count the company field if it is there, if not it counts the lastname field instead

query perhaps... or a form they will be used in both so Im not sure which is best. All Ill do then is add a prefix, and add 1 to the number (i.e. im making a customer reference thingy)