Search results for query: *

The error just says syntax error in query expression with an emphasis on the code above. I didn't post the whole thing because it is large, but you asked for it so SELECT Resolution.Date, EmpInfo.[VZW Area Code], tmpEmpOnLeave.[Location Descr], Resolution.[Resolution Type Lookup]...

Hello All, Can someone please help, I can not figure out this error and I can not move forward in my project until I do (((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate] AND (Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND ((EmpInfo.[VZW Area...

Thank you, but my issue was not with dlookup because I was trying to get to the actualy record and edit that record. I noticed dlookup mirrors the information in a new record. I had to fix my tables and the subform automatically populated. Thanks for the reply.

Yes both are correct. I figured this one out before anyone replied. I extracted the unique employee information from the feed as well as the unique claim info from the feed, then linked the two. Thanks for replying.

Hello All I have a main form which has a subform. I need the subform information to populate into the subform according to a number on the main form. Currently I am trying dlookup to retrieve this information. The main form has an Employee ID, I want the users to be able to copy and paste...

Hello all, I have a situation where I get a feed of information. This information has to then be broken down by queries to be seperated between employy info and claim info. I am having trouble with the relationships because from the feed file comes two necessary numbers (claim code and...

Figured it out thanks a million Remou

Good morning, Hope your weekend was well. I came in this morning excited to complete this task however after breaking all the code up neatly and trying to run it I received a "Complie error: Invaild outside procedure" in reference to "INSERT INTO EmpOnLeave " Can you help?

Sorry to be a bother, but I'm so close to getting this. Now I get a Syntax error with emphasis on the SELECT section of the statement

can you assist me with why I'm getting an expected list separator or ) with emphasis on the INTO section of the statement error Thank you

Thanks Remou you are a genious. Everything worked in a query, now I'm trying to apply the code to VB, but it's getting a syntax error on the code there DoCmd.RunSQL(INSERT INTO EmpOnLeave ([Date Loaded], ID, [First Name], [Last], [Job Title], Function, [Location Descr], [VZW Area Code]...

I am stuck right now and would really appreciate any assistance anyone can offer. I am trying to avoid getting duplicates into the main tale of my database. So far I have all records being imported into a temp table. What I need is to check the temp table against the main table using VB...

I have no code for this situation as I am unsure of the correct coding to check my import file against my current data (to avoid duplicate entries). DLookup being a Access application is not a problem for me, can you just explain which is better and how I would achieve my desired results. Thanks

Hello All, The current issue I'm having in my database is the same as thread707-1203611. I'm just confused as to the correct coding to fix this issue, I have not to date used the Recordset property, and have only used DLOOKUP in Excel. Can someone please help? Thanks in advance.

Thank you so much for your help. I had the table settings on yes/no instead of text. Everything is working beautifully. Thx

I placed the code above as an event on Form current (in subform) however for some strange reason I'm getting a field referred to in expression can't be found error. I even tried to add a blank space entry to the combo box selections to no avail. Have any idea why this is happening? Should I...

rjoubert, Thank you for all of your assistance, I've realized why I'm getting errors. ServiceDt is a field on the main form and cmbFML is a field in one of the sub-forms on the main form. So, would I have to code the main form instead of the sub-form and how can I pass the main form value to...

When I place the code as an event on Form Current I get an invaild procedure call or argument message

rjoubert, I tried your suggestion, however I still get the same result. Am I placing the code in the wrong location? Right now I have the code as a Before Update event. Is that appropiate or is there a better location? Thanks for you assistance.

I actually have two questions: 1. How would I program/format a combo box to be null/blank until the user actually chooses an entry. Right now the box automatically choices it's default answer, but I would like default to be blank. My second issue: I have a combo box with simple "Yes" or No"...