Search results

Like what I see from RW00's union query suggestion. Pretty sure this will work. Thanks Andy Tag SELECT mechanic.Mechanic1, Weekday([date],2) AS weeday, mechanic.equipment FROM mechanic WHERE (((mechanic.Mechanic1) Is Not Null)); UNION ALL SELECT mechanic.Mechanic2, Weekday([date],2) AS...

The database fields are Equipment , ScheduleDate, Mechanic1, Mechanic2, Mechanic3, misc... Problem creating a chronological query of mechanics by day of week.

Purpose, generate a weekly maintenance schedule. The schedule need to be sorted by mechanic, by day of week.

Hi I am Andy and having trouble creating a query. I have three mechanic fields in my database. Up to three mechanics can be assigned to a record. Along with some dates and other equipment fields. I want the query to return a list of mechanics by day. If it were one mechanic per record it would...

Thanks for your help mylistbox =null not sure what to do with this? arnelgp your snippet of code works great but it actually behaves the same way with or without it. Hence the problem, I do not want it to follow the last updated record. I want to return to the list box where I left off. In...

What code?

Hi all, :banghead: I have a list box with hundreds of line items sorted by due date. The list box has a dbl click command that opens an update form. Here the user makes changes and hits a command button that send the data to SQL (like a new due date...), it requery the list box, it closes the...

Minty thanks for the response. We use LAN connection. Once I figure out how I can try your view query suggestion. Thanks.

I am new to Access and SQL, it appears to be front end. I am linked to the SQL server.

Thanks, you are correct they are links. Any suggestion what could be causing random delays?

I recently created a form that consist of several list boxes. When the form is opened Several SELECT queries run. I have been receiving feedback from folks that use the new form that sometimes they have to wait up to a minute before the form loads. It is not always the case sometimes it milli...

I see! Thanks for the feedback.

replacing + with & worked. Thanks!

Thanks Namliam, I made the change, however I still receive the run-time error. Script stops at the populates SQL step. SQL OriginationDate field is set up as date/time. VBA doesn't have Datetime only Date. Dim OriginationDate As Date ' Date service request is made OriginationDate...

Still received a run time error 13 type mismatch. Dim OriginationDate As Date OriginationDate = Now MsgBox (OriginationDate) 'This populates all data from form to SQL KRFsSQL = "insert into krfdatabase ([Author], [Area], [comments1], [OriginationDate]"...

Msgbox returned date time Now(). However still received run time error 13 type mismatch.

OriginationDate = Format$(Now(), mm/dd/yyyy hh:mm) any suggestions on date format?

:banghead: Good Morning I am new at Access/VBA and this forum I get a run-time error 13 type mismatch error when I Dim OriginationDate As Date. Code runs fine when Dim OriginationDate As String Any ideas? 'Option Explicit Dim KRFcon As ADODB.Connection Dim KRFrs As...

Ah, yes! Thanks spikepl. Auto Correct:D

I used Jon Big Booty's "Dynamic search multiple fields" snippet. Real nice! Just noticed that if I start the search criteria with letter "i" it chokes "error 2110". Weird?? If I use a cap letter "I" and any other letter but "i" it works great.