Search results for query: *

I know one of you is going to make me feel real stupid about this question....but here goes. I have a table called Components, which has a list of components and an ID number for each one. On my form, I have a combo box for components, which when selected will be inserted into another table...

In MS Access, I have a large group of queries that use a module I wrote called IsInDay. We collect data by shifts, but our 2nd shift runs a couple of hours after midnight, so when you query data using a shift and a date, it misses the entries after midnight. The IsInDay module, looks at the...

Hi GPOTony, Thanks for the idea. The problem is I am using MS Query. When I use MS Query, create the obdc connection, and select the ShiftDate field, then I receive the error that "Undefined function "ShiftDate" in Expression" Somehow I have to get Excel to recognize that...

Well, I tried copying the module to Excel, and I am still getting the error "undefined function "ShiftDate" in Expression" whenever I try to select a query that is using this function in access...which is all of my queries by the way. I am not a very experienced Excel user...

I want to link several Access queries to an Excel spreadsheet, instead of using DDE....... In my queries, I am using a Module called "IsInDay, so that any data time stamped between the hours of midnight and 3 AM, is considered to be the previous days data. Here is the code: Option...

I want to link Access queries to an Excel spreadsheet, instead of using DDE....... In my queries, I am using a Moduld called "IsInDay, so that any data time stamped between the hours of midnight and 3 AM, is considerde to be the previous days data. Here is the code: Option Compare...

Thanks so much Craig..I am kind of a novice at this.....Just as I got the email for your posting, I was poking around in the Table and Relationships Forum and saw a similar reponse for someone else who had the same issue. I love this web site....in just a small amount of time I have found...

I have a cascading combo box issue. Actually it might be more of a relationship issue, so here goes. I have a table with a list of components and a table with a list of sub-components. I want to set up cascading combo boxes, so that when you select a component, only the sub-components that...