Search results

Hi Chris If you are running your log through a form then you could run a Data Append Query as part of the forms 'On Load' event. That way each time you load the form it would automatically update your local table. Link the local table to the ODBC table through Employee ID (I assume that is...

Either that or add watch points for all relevant data (Debug menu)

I think you need to be a bit more specific What have you tried and what can't you get to work. - The Criteria (post #5 / #7) will do what you said you wanted to achieve in your original post (unless I am not understanding) i.e. You have a simple table and you want to extract all records for...

You could use a Case Select statement to assign properties to buttons 1 to 5 depending on whether button A,B,C or D are clicked. Such as: Select Case ButtonClicked Case ButtonA Button1.Caption = "Do This" Button2.Caption = "Do That" Button3.Caption = "Do Something"...

If you use Access Query Design you can add tables and fields to a query and then specify criteria for any field you include in your query to select which records are displayed. Therefore, if you select the field that holds the qualification data (along with whichever other data you want to...

Create an SQL query to collect the data for your report. Something like: SELECT [Daily Log Sheet].[Client ID], [Daily Log Sheet].[First Name], [Daily Log Sheet].Surname, Count([Daily Log Sheet].[Client ID]) AS [CountOfClientID] FROM [Daily Log Sheet] GROUP BY [Daily Log Sheet].[Client ID]...

Field Criteria '<>"Qualification X'

It seems to be a Microsoftism where it doesn't matter what data type you set the column to in Excel or what data type you set to import it to in Access - Access will read the first line of data and determin what data type it should be therefore 656111 will be imported as long integer...

When you say your data is stored in an excel sheet which you import into access. Does this mean you import the spreadsheet in each time you want to use it or whenever it is updated. In which case you would be better linkeing to it rather than importing it, that way you would always be working...

To run the code on a button click use the "On Click" Event and enter the following code. You will also have to code what you want to do into the sub-routine unless you have declared the variable 'result' as a public variable in public declarations within the database/form otherwise it is only...

I have set up a with a Combobox and a textbox. The Combobox allows the selection of Parameter via an SQL statement and the result of the DLookup is shown in the textbox as a result of an 'AfterUpdate' sub Routine, see below. Private Sub Text3_AfterUpdate() Dim Result As String Result...

What are you using to call the sub routine?

This should work: Sub boo() Dim result As Variant result = dlookup("Definition", "Config", "[Parameter] = 'Mail Folder'") End Sub By setting result as Integer will result in an error because DLookup will return "TS"

I assume ElapsedTime is a Public function, in which case the following will return 00:00:00 if one time value is missing: Public Function ElapsedTime(startTime, endTime) Dim Interval As Date ' Calculate the time interval. If IsNull(endTime) Or IsNull(startTime) Then...

You could check for Null, not sure how this would work in a query but something like: If Not IsNull([TIME IN]) Or Not IsNull([TIME OUT]) Then 'Duration: ElapsedTime([TIME IN],[TIME OUT])' End If

Hi All Forget this post - apparently this is a well know, long standing bug with Access. So I have switched to a single form with a listbox to select which record to display. Have a good one! Dave

Am I missing something here? I have a split form wich shows individual record details in the top half and datasheet vie in the bottom half. The form settings are as follows:- Default View - Split Form Allow Form View - Yes Allow Datasheet View - No Allow Pivot Table View - No Allow Pivot...

Finally figured out how to extract the check box data. I have posted it here to help any one else with the same issue. Dim oTbl As Table Dim oCell As Cell Dim oCBox As FormFields Dim strFFName As String Set oCBox = doc.FormFields ' ***** Loop for every formfield...

Thanks again Anakardian With the following mod that worked fine Dim oCell As Cell Set oTbl = ActiveDocument.Tables(x) For Each oCell In oTbl.Range.Cells With oCell 'do stuff End With Next oCell Just need to figure out how to extract data from...

Hi Anarkadian Thanks for your help with this. I have found this code from Gary Mayor on the answers.microsoft.com web site, which seems to work. Dim oTbl As Table Dim oCell As Cell For Each oTbl In ActiveDocument.Tables For Each oCell In oTbl.Range.Cells With oCell...