Search results for query: *

ProgramError, I have something similar on the boil at the moment. I Have used the 'Table' option as I can store details about the room as well. Don't mind sharing if we can help eachother. Solo7 [thumbsup2]

My first thought was that Excel was mainly in B/W anyway - But then I woke up and realised that some numnber formats allow the representation of negetaive numbers as red. So I took the time to try and replicate your problem, but with no sucess. So here are a few guesses if you havn't already...

Ok I've been working on a form for some time now and it works perfectly (famous last words!). I now need to copy my form and replace one piece of code throught. I need to change EVERY reference in my form to TblMod3 to another table, ie TblMod2, and then copy the form again replacing TblMod3...

How about usuing the DLOOKUP function on the combo box's AFTERUPDATE event. Build the selection criteria by referencing the target box that holds the search criteria. So if you have selected data from the combo box Combo1 then use something like TextBoxAutofillMe.Value =...

ZmrAbdulla Thanks, I think the OnActivate event will do it. Solo7

When my form opens it is in full screen (docmd.Maximize) but when I view a report it re-sizes in the bacground of the report - so when I close the report view I have a re-sized form. Solo7 [thumbsup2]

I think I have this one now. I have taken out the setting of the controlsource of each textbox and placed it in the Reports 'OnOpen' event. Referencing the combo which selects the different tables on the open Form - I would have liked a more clinical solution but this seem to work fine and I'm...

RivetHed Couldn't help but it try asap. The code seems logical to me but I'm getting an error 'Property is not availiable in design view' The field name of each textbox is in the .Tag field, so the field Fld_Mod3_TestTime is the name and is in the Tag. All my fields are as the example, I need...

Rivethead, I think that may well do it. Will try when I get home - Many thanks in advance ... solo7 [thumbsup2]

Sorry rivethead, pressed submit a quickly The user selects a Table to query from a combobox on a form, and at the same time a range of dates to query between. These 3 parameters are then joined into an SQL statement. I open a report in design mode at runtime, set the recordsource of the...

Yes. I was hoping to use this one form instead of 7 if I used seperate queries. It is just the Table number that is different I have TblMod1 - TblMod7. solo7 [thumbsup2]

Ok, imagine you have set up a report with a wizard. Basing the report on Table3. It's got 2 text boxes both pointing to say a Name field (TXT_Tbl3Forename and TXT_Table3Surname) - you open the form and the correct data is displayed as you would expect. Now what I have done is to allow the...

Thanks for the reply Remou but It's not what I need. I'm trying to use 1 report to display data from multiple tables and it's the user parameters that decide which table the report looks at. I can sucessfully set the reports recordsource to the correct SQL but it's the text boxes that are my...

I am using SQL to set the record source of a report based on 2 parameters chosen by the user. My user selects a table to look in, and then specifies the dates to search between to perform the query. My report works ok for a specified table but as soon as I try and selct a different table the...

I have an ADODB Recordset which I want to export to a CSV file. However i need to play around with some of the fields before export, ie change the Name field to 2 fields consisting of First Name and Surname - So John Doe in my DataBase will be 2 columns in an excel CSV file. My theory is to...

Top marks PHV the simple solutions are so humbling ... Thanks for that, the DCount was just what I was looking for I was just looking too deep solo7 [thumbsup2]

Sounds great traingamer , But it's the first time I've come across the Select Count(*). So if I was to use the following SQL: SELECT TblMod2.Fld_Mod2_Index, TblMod2.Fld_Mod1TestResult FROM Tb2Mod21 WHERE (((TblMod2.Fld_Mod2TestResult)="""")); as a control source in a text box, How would I...

I am using the following code sucessfully to retun the number of records in a SQL statement. Dim StrSql As String Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection rst.CursorType = adOpenStatic '---------- Get count for Module 1 waiting...

I'm using a DTPicker control in a form. The date is set to display a Custom format set to dd MMM yyyy - and this works fine every time I select a date the correct date is shown in the box. However when I reference the DTPicker.value I always get the American date format ie MM dd yyyy - so when...

BiggerBrother I think that has got it - It lookes like I NEVER closed the connection. Thanks !! solo7 [thumbsup2]