Search results

Doh ... typo. Do While Time < start + 0.02 should be Do While Timer < start + 0.02

Wasn't sure whether to post this here or in the forms cat. As it involves code, I chose here. I'm trying to simulate a progress bar within a form using a textfield. I've found the following code on t'interweb but cannot get it to work. When I click the command button to start the progress bar...

Yeeeeeaaaaaahhhhhhhh!!!!! I create 2 new queries ... 1. Just opens all fields in services_desktop and s1_quotes 2. Based on Query1 above uses the following very simplistic SQL: SELECT * FROM Query1 WHERE s1_quotes!description LIKE "*" & services_desktop!service_id & "*"; And it worked :-) Yay.

Right ... next I've got rid of the "Services_Desktop" query and split the service table into 3 separate tables. So we've got services_desktop, services_network and services_xtower. If I amend the above query for each table ... only services_tower returns results with no errors. The other 2 give...

I've changed the Services_Desktop query to return different results and it now works (without any ' either side of the *s). So it must be something to do with the data the Services_Desktop query was returning :-s I've tried a few different combinations of filters on the Services_Desktop query...

My SQL so far: SELECT s1_quotes.* FROM s1_quotes WHERE (SELECT [Services_Desktop]![service_id] FROM Services_Desktop WHERE [s1_quotes]![description] LIKE "*" & [Services_Desktop]![service_id] & "*"); s1_quotes is a table with a "description" field which is memo format as it contains too...

Ah ... got it!! I was trying to do it in Design view. Simply dragged the form frame in form view and saved and got it. Christ ... I feel like a fool *blushes* Thanks.

The form is based on a query ... and the results will always be 3 records. I don't want any more to show. There is a property on the detail part of the form for Can Shrink but I have tried that on/off with no change.

Tried that ... no change (except no dividing lines - still big gap) :-(

Ha, there is hope then! I've tried googling and googling but with no luck. Guess I'm not getting the terminology right :-/

I have a continuous form based on a query. The recordset returned will always be 3 records - but as far as I can see this shouldn't be relevant. Therefore, I'd expect the form (in form view) to display the form header, the 3 records and the form footer. I've disabled the ability to add new...

Just had a chance to test it & it workings great! Thanks :-)

Thanks for the reply. I'm trying put this into code which opens the file first, etc. Getting stuck ... have got this far: Function ClearTemplates() Dim objExcel As Excel.Application Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True Dim wbSrc As Workbook Set wbSrc =...

I need some MS Access VBA code which will allow me to delete all rows from a specific workbook (which contains a single worksheet) EXCEPT Row 1 which contains the column header. There is actually only 1 column of data (which gets populated with rows and rows of reference numbers) ... so this...

Thanks Chaps :-)

To adapt this further ... is there a way to add multiple criteria to this statement, referring to a different column? So I'd like to know how many records have "SPECIAL REQUIREMENT" in column E (as above) AND the statement "Commissioned" in column D. I've tried...

Spot on! Thanks :-)

Here's the scenario ... I have a column of data (no of rows will change) and I need to know how many records contain a specific phrase within the cell value. The whole cell value will not match the specific phrase but it will contain it. e.g. How many cells in Column E contain the phrase...

Hi Brian Thanks for the reply .. it worked perfectly (yes, I noticed the space thing ;-)). I cannot thank you enough!!!!!

I thought it would be something like that. Hmm .. does anyone know how to incorporate the date formatting function into the countif??? I thought about just having a hidden column containing your date formatting function - but then if the corresponding value in column D is null it populates...