Search results

The query is not returning any data.

Sorry if I wasn't clear. I'm running it throught SQL QA and it is not running correctly.

I have 3 tables: PROJECTINFO, RECEIVEREC, CONTACTS. PROJECTINFO is my parent table and RECEIVEREC & CONTACTS are the 2 child tables. These two child tables have a one to many relationship with the PROJECTINFO table. Instead of permanetly deleting records from these 3 table, I am recording...

Thanks! That seems to have done the trick.

I have a table that is being created each time by a query named MyTable. In this table are 2 fields: CountyName and NumVisits. The CountyName field contains the county name and the NumVisits contains a numeric value. I inserted a Microsoft Graph 2000 unbound frame object into my report. I...

Thanks for your help. This bit of information allowed me to build the following query: SELECT (IIf(Year([TotalVisits.Visits])=Null,Null,Year([TotalVisits.Visits]))) AS VisitYear, (IIf(Month([TotalVisits.Visits])=Null,Null,Month([TotalVisits.Visits]))) AS VisitMonth FROM TotalVisits;

This is probably a stupid question, but I can't find any info on how to query data from my table based on a year. I have a table that contains dates in the following format: mm/dd/yyyy. I want to be able to query all records that have a year of 2004. Can this be done without having to enter a...

Is there a way to change the system date on the computer using VBA?

I tried adding /B to the exit command but it seems to have no effec. I'm using Windows 2000. Thanks, crhodus

I tried adding EXIT to the .BAT file and it somewhat work. When I click on the .BAT file, it opens the database but the DOS window stays open. Once I close Access, the DOS window will also close. I'm using Access 2000 and Windows 2000.

This isn't really a vb question, but I wasn't sure where to post it. Is there a way to have the MSDOS window colose after the batch file has finished running? I've got a bat file that is opening an Access database. After the mdb file is open, I want the Dos window to go away. I know a...

I tried using the compact and repair option, but the breakpoint problem still occured. I ended up removing the code and then saving the form. I then went back into the form and pasted the vb code back into my button onClick event. So far, the breakpoint problem has not occured agian.

At one time I had a breakpoint next to an IF THEN statement. Before I copied my program out to production for my users, I removed this breakpoint. Sometimes when the user is using a form, the Visual Basic editor will launch and the IF THEN statement will be highlighted in Yellow (along with...

On my Form I have created code that will launch a message box telling the user they must enter a project name and project manager before they can close the form. If the user decides not to enter a new record and want to discard the changes they have made, they can press the escape key and any...

Jon K, I replaced the double quotes with Null and this seems to have corrected the problem. Thanks for your help! crhodus

I'm using the following query to populate a temporary table: INSERT INTO tmpMailMerge ( project_id, comp_name, company_prefix, company_contact_name, mail_add_1, mail_add_2, mail_city, mail_state, mail_zip, mail_country ) SELECT project.project_id, Company_Info.comp_name...

I finally got the statement to work. This code would not work: Me.subFollowUp.Form.RecordSource = "Select * from Project WHERE ( [project_mgr]= 'Alan Ray' OR [project_mgr]= 'Joe Roberts' ) ORDER BY Project.project_mgr, Project.FollowUp, Project.project_name;" But if i do this, it work: dim...

Thanks for your help. Instead of using the On Current event, I added code to the On Open event. But I've run into a problem. I'm receiving the following error: Run-Time Error '3705' Syntax error (missing operator) in query expression '(( [project_mgr]='Alan Ray' OR [project_mgr]='Joe...

I tried doing what you said, but I'm receiving a "Cannot build a link between unbound forms". What I've done is create a main form (frmTickler). On frmTickler, I have 2 subforms (subFollowUp and subNonFollowUp). Besides the 2 subfomrs, frmTickler only has one other thing on it - a Close...

How can I pass a value to a subForm? I have a subForm (subFollowUp) on my main form (frmTickler). I would like to be able to pass a value to my subform so that only certain records are displayed in the Subform. The default Record Source for subFollowUp is "SELECT * FROM Projects;". I'd like...