I have been working on an Access project but I don't have the experience to be able to create the functionality I need in such a short amount of time (by...

I have a user-defined function that I put in a VB module. During the "Main Menu" form_load event, it fills a Global Variable (uidUser) with a number that I use...

I am trying to update fields in one table (Table 1) with a field(s) in another table (Table 2). In the update to line I use the following for Field1 and...

Hi! Everybody........ Anyone help me how to calculate Opening stock, Stock-in-hand(closing stock), stockreceived, stockissued in single query of stores. Is it...

I have a table - Work Orders - which includes fields for a service person and hours worked on the order. I have another table which contains the hourly rate...

I have a table in Microsoft Access whereby the field, 'msgbody', is of data type 'Memo'. I have the following query with the name 'inboxIns': PARAMETERS...

Hello, I have an append query that I run, which usually I append about 300 records per update. My question is Can I run the append query while other...

Hi, I am trying to create a query to show the last time a motor was greased. Since we are working with several different motors, I need the Equipment ID field...

I have a query where I'm selecting fields from two tables - Students and Attendance. I have selected option 2 in my Join Properties, i.e "Include ALL records...

I've created a employee training database and am having trouble with the user supplied parameter query. A couple of issues: I have an unbound form (AdHoc)...

I'm having an issue where performing an outer join between two linked ODBC tables performs exactly the same as an inner join. I read a MS KB article that...

I'm running a query which contains 5 columns 2 of these colums and can contain diffrent values. if the combination matches it should not show the entire row....

I am working on a small database am stumped. I have written a two select queries that are being used for data entry. My problem relates to three tables. For...

Hi Guys, I hope you can help. I am a novice. I am trying to run a report from a query to give me the birthday's for today and so on. The birthdates are...

I am running an update query that is updating text to CLng. I receive a message that all the records weren't updated due to a type conversion failure. All of...

I'd like to continue using a GUI to construct queries, as mine are always ad hoc and unique (stored queries don't help me). ODBC is proving to be too slow,...

A query only has one user prompt; but when run, it prompts the user twice to enter the same information. How do I get it to only prompt once? Any help would...

Is there any way to prompt the user for a new table name in a make table query? I want to be able to save the table data each time the query is run and not...

I am trying to build a report that will accomodate a crosstab that returns an unknown number of columns. I'm looking to write a query that wll tell me the...

I have a form that the users select a project name and enter a date to and from. I would like to run a cross-tab query that selects the records that equal the...