Search results

thank you for responding...... When I run this query it is given me the following back... PROJ_ID--- UPDATE_DATE--- WEEKLY_UPDATE ---87 ------ 3/25/2003 ------ another test ---90 ------ 3/28/2003 ------ hello ---91 ------...

I have a table called tbl_Weekly_Update. The following is what is in that table. PROJ_ID-----UPDATE_DATE-------WKLY_UPDATE ---87------------3/24/2003---------another test ---87------------3/25/2003---------this is a test ---90------------3/25/2003---------one more I would like a query that...

Hello, I am receiving a compile error: Syntax Error when executing this code on my save button. The debugger highlights what I have highlighted below. Any advice would be greatly appreciated. Private Sub Command9_Click() On Error GoTo Command9_Click_Err DoCmd.SetWarnings False '...

Thanks for the advice! I will try it. Kacy ________ Valium Rehab Advice

Thank you very much! ________ Vapir no2

Thanks for the advice.....One more question. How to you convert macros to VBA? Thanks, Kacy ________ Blonde Latina

ghudson, I'm still receiveng the runtime error 3021 when there are no records. I put the code you supplied as the first thing to run in the AfterUpdate event. The debugger is highlighting what I have highlighted below. As for as running macros.....you would probablly have a stroke if you new...

Thank you! ________ List of subaru engines history

ghudson, Ok, Here's what I got. I have a macro running on the AfterUpdate. So is it all right to put the code you supplied in the "On Change" I tried the following code below and I am receiving a compile error that says Label not defined. When I check the code it is highlighting the "Resume...

I tried to do a requery macro on the AfterUpdate and it seems to work. Is this method allright? Also when I tried the code you gave me I received an #error. Thanks for the advice. Kacy ________ SC2 REPLEYS

Hello, I have a combo box that hides the primary id and displays the Facility Name. When a facility name is clicked on I would like for it to automatically look up the facility manager. Here is the DLookUp code that I am running now, but nothing is happening...

Simple "On Open" Code Hello, I know nothing about VB, but I am looking for the code that I would use to run a query on the "On Open" Thanks in advance, Kacy ________ WHOLESALE VAPORIZER

Hello, I have two tables.....1.) Products, 2.) Inv_Transactions. I would like to write a query that includes all the Products even if there hasn't been a Transaction with that query. Here is the query I have know, but it does not include Products that have not had any transactions because...

I have a combo box that looks up information based on what was selected in the combo box. If there is nothing in the table (Which is likely, b/c it is an appointment scheduler and appointments get deleted once they are past the current date) I receive a run time error 3021; No current record...

Before anyone puts any thought into this I created a form that has Date Range and used it. I copied the date range form from the Inv. tracking template that comes with Access and it works. ________ Big boobies

I created a report that receives it's data from a query. The query has criteria that asks for a "Start Date" and an "End Date" Is there any way for me to display on the report the date criteria that was entered in the query. So the report would say something like...."For transactions...

Thanks a ton! Thats what I needed. Kacy ________ Suzuki gt750 history

On a form that I have calle "Add_Products" it allows users to type in new Products. Once the Product info. is typed I have a save macro. I would like for it to do is Save the Product Info and Set the fields back to blank so they can continue with another product. Hopefully this is easy...

Is there anywhere I could look up stuff on subselects??? I am not familiar with them. Thanks for the advice. Kacy ________ Toyota 7m-ge specifications

I have done something similiar to what you are attempting. I don't know if it's right, but it works. Create a table with all your fields you want and call it archived (or whatever). Create your macro that contains "RunSQL" command. In this command use a append query to the archive table...