Search results

I am using this subroutine which uses the function shown below. What I have found in my testing is that when I do not already have Excel open and I try to run the code, I get an ActiveX error, but when I simply open Excel before running this, I don't. Can someone tell me what the cause of this...

there are many other columns on this table, but I just mentioned 3 of them to illustrate my point.

I have a table that has 3 columns (ID, STOP_NUM, NUM_STOPS). Every time I insert a record for an ID that already exists, I need to update the NUM_STOPS field to the total number of records for the given ID. For example: ID STOP_NUM NUM_STOPS 1001 1 1...

Does anyone know how I can convert this Oracle crosstab query for use in Access? I was able to get the data to return the correct results using Oracle but I don't know how to write it using Transform and Pivot. SELECT y.process_date, y.loc dealer_code, l.p_dlrgrp dealer_grp, l.p_div...

Thanks, that did it.

Are you saying that I should change this AfterUpdate event to BeforeUpdate?

Yes I did. No luck.

I have a form that has a subform in which users can update a field called APPROVED_COUNT. If the count in this field does not equal another field called ROW_COUNT, I pop up a message to alert the user of the issue and if they answer YES to the message, I want to return right back to the record...

I have the following code that I have been working on and the requirements have changed so now I need to create a new flatfile each time the LOC field in the PRESOF table changes. I would like to name each file spoolSOF_<LOC>.txt I'm not sure I know where to begin. Can someone give me some...

This is not right. I wan't the combobox default to be the result of the query called QRY, which in this case if 5.

For some reason it's not working. Please take a look at the attachment.

Set it to what? The name of the query?

I have a combobox called cboMaxVal. When I open a form called frmMain, I want value in the cboMaxVal to be set to the query qryGetMaxVal. Currently when I open the form, I need to click on the dropdown arrow before I can see the value from the query. Is there a way to have it appear in the...

I have a subform that returns a bunch of records. Each of the records returned has a LANE_ID, so in this example, there are 10 records returned, 5 with LANE_ID = 11111and 5 with LANE_ID = 22222. Is it possible to alternate the backgrond color for each of these groupings? I have found examples...

OK, I went with the string variable option and it works. Thanks a lot for the help! Now, I have a "Clear All" button that I need use to wipe the listboxes and the data in the subform clean so the user can start over again. I can wipe the listboxes clean but I don't seem to know how to empty the...

Aha...I think I'm getting it now. Once I run the query, do I requery the main form then to fill the subform with the results?

I agree, this is not very dynamic, and I can work on that later. I still don't understand why the subform pops up? It has a default view of datasheet. I guess that baits the question...what is the proper way to create the subform? I had created it from the query.

I have a form where users select from different listboxes which I then use to build a SQL statement to return the matching records. On the main form I have a subform that is based on the query that was just created. The problem is that I can't seem to get the returned records to display in the...

I have a combobox called cboShipDay that has the days of the week (M-F). I need it to default (highlight) to the current day of the week. How can I do this?

Thanks. I was able to fight through this issue and it's working now. The problem I have now is how do I display the results of the query in a subform? I have tried DoCmd.OpenForm ("subfrmDynamicQuery") but it still pops up a new form in spreadsheet view.