Search results

Maybe you could use the Shell function to run ipconfig /all and parse the MAC address out of the result. Would you share with us what you want to do with it?

Since it was complaining about the date function to help you figure out what this is try running the following query and see if that works. SELECT Date() AS Thisdate; If that gives you an error and your references are ok another thing to try would be a compact and repair.

One thing I've found that will cause weird errors like this is a bad reference. I suggest checking them (VB Editor, Tools, References) to make sure they are ok.

If the 30 field are to receive the same formatting you can just selected them all (shift click on each) the the conditional format will apply to all of them.

I think the expression needs to be in quotes. I suggest trying: c.FormatConditions.Add acExpression, acEqual, "[ETC] < Date()" Also this might help.

If [ETC] is a Date/Time field I don't think you want any limiters at all. The following screen shot shows how you can enter this rule. Why don't you just add these rules through the ribbon rather than putting it in the Form Load?

It sounds like you want to prefix a query with some data. Maybe could create a table to hold this "certain text to appear in cell "A1", followed by the column headers in row 2..." and then create a query of this table. Then join this query with the query you already have with a union query...

Suggest this video to get you started.

You shouldn't need any VBA for this other than to requery the combo box in the events where the row source would change, e.g. , on current, after update, delete. The main trick is getting the row source query of the combo box right. I think you were headed in the right direction with trying a...

If you want to upgrade your programming skills I suggest watching this video series on VBA.

@JHB Good catch. I tried that and that solves the problem but it's still a mystery to me how that could have happened unless some sort of corruption is going on. The screen in the wizard on which you specify data types doesn't allow you to leave the Data Type blank.

While I haven't been able to figure out the cause of the error I suspect that the specification is the culprit as I've been able to create one that works in the the attached database. The one I made is named CheckDispostionsSpecification and if you compare it to yours by running the qrySpec I...

Not that I think it's the problem but why does the CheckDispositions table have a field named RunDate that doesn't exist in the text file?

I was able to import the file when I made a spec with all of the fields as short text so I expect there may be a type mismatch going on somewhere. I'll try making a spec like the one causing the problem now.

Since this says all of the arguments are optional I suggest leaving them out one by one to find out which one is causing problems. If you can upload that part of the database, i.e., at least the table, spec, and a sample text file I'll see if I can figure it out.

You can check this list. One of the field on the join needs to have a unique key. Suggest check that first.

Thanks Jon. Looks like it's working for me now.

This is usually done with a subquery. The Get the value in another record section of this web page should get you started.

You could do this with an aggregate query. Please refer to the attached database for this discussion. Before you create an aggregate query you will need to translate the individual months into a grouping. If you look at the MonthGroups table in the attached database you will see that it maps...

If you would be happy to call 365 days twelve months then something like SELECT Employee_track.FirstName, Employee_track.[CPR TRAINING], Employee_track.[FIT TEST], Employee_track.[EQUPI CHECK] FROM Employee_track WHERE (((Employee_track.[CPR TRAINING])<Date()-365)) OR (((Employee_track.[FIT...