Search results

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...

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...

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...

: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...

Hi I am Andy Taggerty I work a Eastman Kodak Co. in Rochester NY. After looking at post posted on this forum, I consider myself a beginner. Looking forward to learning more. Access/SQL is very powerful and we need to transform a lot of Excel applications to Access.