Search results

try the below SQL SELECT BaseTable.[ID #], BaseTable.[Last Name], BaseTable.[First Name], Max(CrtSubTab.[Pending Court Date]) AS [MaxOfPending Court Date] FROM CrtSubTab INNER JOIN BaseTable ON CrtSubTab.[ID #] = BaseTable.[ID #] GROUP BY BaseTable.[ID #], BaseTable.[Last Name]...

so basically you need to retrieve the number before the front slash /?

That write Springfield to be exact.

Can you post an example db and I will show you. You can take all the data out if it is private. I noticed you are from central Illinois, what city are you in?

Where = "cardnumber = '" & CardNumberGlobal & "'"

First just create a query object so that you can manipulate the SQL. Then you can open the querydef in code and update the SQL Statement. Something like below would work or at least give you and idea Dim def As QueryDef Set def = CurrentDb.QueryDefs("queryName") def.SQL =...

Include the table in your query.

check out the example. Is this what you need?

lookup the Weekday and WeekdayName functions

Looks correct to me. Why not join tblMembers.MemberID to [tblEvalResults].[FlightExaminer]?

Sometimes you just need an outside opinion.

Look up the tableDef object in VBA help.

What you could do is save the variable to a cell on the spreadsheet and then write a function in Access to look up the value in the Excel cell.

Do you have user level security on the db? If so you can use the CurrentUser() function to retrieve the user name of the person logged in. If you dont have User level security yoiu can use Environ("Username") to retrieve the name of the user logged into windows. From there you can determine...

You need the security file .MDW I believe. You will also have to setup a shortcut for the user to access the db. What I would do is send along a word document with a command button on it that runs a macro to create the shortcut using the correct security file.

Why can't you get it to work? What happens when you try?

Basically what you need to do is create an invisible form and set it as your start up form. Then you can open your swithboard on the open event of the invisible form. Next use the timer event to run some code to check if the current time is past 5.

have you tried the text-to-columns feature in Excell? That may do the trick

There is a program called Monarch that is used for this type of request. You could probably write a VBA funciton to parse the data.

What is the expression you are using?