Search results for query: *

Hey All, I have been searching all over the web trying to find a solution to my problem. I have a FE and two BE access database. One BE is used to house the table that is modified by the user and one BE that is to be used for reference only. My problem is this, when I link tables from the...

-------------------------------------------------------------------------------- Alright guys, I am beating my head against a wall with this one. I am a new access programmer . Here is what I have; One MDB that has a couple of tables for storing data and another MDB that will be used as a...

Hey Guys, I have some code that converts a range to HTML for insertion into an email body. It works fine and dandy on my machine that has VBA 6.5 but when someone tries running the code that has VBA v6.3 they get an can't find object or library error. I cannot find the reference to enable to...

Hey Guys, I am sure the answer to this is very simple I just can't find it anywhere on the net. What is the function in Jet SQL to convert a date time (07/13/2009 13:30:00) to just show the time (13:30) Thanks

I am using toad to query an MDB. When I try to run the below query I get a "Microsoft Access ODBC too few parameters expected 1" error. Anyone have any thoughts? Thanks SELECT DISTINCT agtdata5.AGENT_ID, agentA.AGENT_NAME, agentmap2.HIRE_DATE, agtdata5.MU_ID, agtdata5.AGENT_DATA_VALUE...

Hey Guys, I have an access database as a store for some data. I have a custom function in my MDB that is basically a CASE statement. It works when build queries within the MDB itself...is there a way I can call on this function when querying the tables externally via an access ODBC...

Hey Guys, I have a bunch of data stored in an MDB. I am using microsoft query to query it and pull it into excel. From what I understand Access does not support Case statements so I decided to use SWITCH instead. The problem is when I get past 15 conditions in my SWITCH statement I get a...

Hey All, Does anyone have some SQL to get me started or maybe a link to a help guide that will get me started? I have a table with schedule exception detail that I need to summarize into half hour incrememnts. Here is an example of what the schedule exception detail looks like. Exception |...

Hey Guys, I am a complete SQL noob and I have searched all over to figure out how to do this but have nothing. I have two tables; TABLE1(USER_ID, DATE, EXCEPTION, USER_NAME) and TABLE2(USER_ID, MODIFY_DATE, MU_ID). I need to return USER_ID, DATE, EXCEPTION, USER_NAME and MU_ID. The tables...