Search results

Excellent, works perfectly. Thanks.

i have a query with 4 columns of data, in most cases 3 of the columns will have the number zero in there and one column will have one word in there. I'm looking for some 'IIF' statement help to formulate a query that will look at each column to see which column has the word in it and then return...

Sorry, i'm looking for the word 'tag' only. There is a field called 'description' and has up to 50 words in the field. I am looking for find any records that have the word 'tag' in the description field.

Hi, i'm looking for a solution for a problem where i want to put in a formula in a query field that will search for an exact word/s within a field in the same query. For example ; Tag: IIf(([description] Like "tag"),1,"") However, words such as 'stage' and 'voltage' are appearing in the...

Thanks arnelgp, that was second choice.

I have just watched this youtube video clip https://www.youtube.com/watch?v=fe5D4iK0Pvk& in the search for the answer for my problem. This video clip shows you how to loop through all the controls (text boxes) on a form and find the blank control fields and highlight them red and alert with a...

You could try this ; Dim time1 As Double, time2 As Double time1 = Timer <your routine here> time2 = Timer MsgBox Format (time2 - time1, "0:000\s\ec")

Hi, I'm looking to teach myself more about the advanced programming of the MS Access Object Library. Just wondering if anyone has any links they would recommend?

Thanks namliam, worked like a treat. Forms("frm_Rollover_Progress").lblProgress1.Visible = True

Hi, I have a problem whereby I have created Form1 with a button and after I click the button Form2 appears (frm_Rollover_Progress). Form2 is a (poor man’s) progress indicator that makes some labels visible after a section of a query has run. I have set the first label on the form to...

Thanks for the infor guys, i've found what i'm after. Awesome work.

Hi, I have followed the steps in the article below and i have managed to get the audit trail working in the form. However, the form is now inserted into a subform and doesnt seem to be working. I have already tried to insert the 'Call AuditChanges("Name") in the subform 'before update' but...

Sounds like the sharepoint might be the go. There are shared folders between Oz and Korea, but there is a 4 minute lag between when you want to access records and save etc...there are 5 people in each location who use the database so is causing the problem. Do you think the Sharepoint server...

In a way I am restricted to using access as the backend, but if i can justifiy a new and quicker way that it can be done better for everyone then i can convince them otherwise.

I am working on a project that has 2 databases located in different locations (Australia and Korea) which is due to the lag in accessing the information from one central server location. At the end of each week, an excel export is done from one database and is sent by email to be appended to...

I have a database which has numbers for different statistics and i would like to be able to search, for example, the past 10 weeks and find out how many time a certain number has been recorded. Any suggestions ??

I have a query that has 2 fields of currency labour rates (current rate and baseline rate), but sometimes there are some blanks in either of the fields and is causing my text field which has a Sum formula (Rates x Hours) to #ERROR and throws out my other calcs. The only way to find out which...

I am working on a Human Resources database for a big project that has a field called 'Position Number' (eg. 290) which is unique for each position. But the position can have up to 4 different stages over the life of the project which is shown in the primary key field 'Position ID' (eg. 290-A...