Search results for query: *

I have a report that is based on a query - it is essentially a calendar based report. I would like to limit it by month. Right now the reports underlying query has (among other things) a date field, and the report reflects all dates. I would like to have a form with a combobox (cboDate) that...

Can someone tell me what I am doing wrong? I record a macro and save it. After I save it (and before I close Excel) if I go to the macro menu, it's there. However, when I close and open Excel and then try to run the macro, it isn't there. How can I record a macro and have it available the...

I have 4 text boxes (txtA, txtB, ... all currency) that the user enters - I need to have a "total" (txtGrossTotal) that is the sum of the four. I would like to have the total value change as the values are entered. Then when the save button is pressed, write this value (txtGrossTotal) back to...

I have been asked to update an access app that was written by a contractor who is long since gone. He has set the forms in this app with an interesting (yet annoying) property - and I haven't figured out how to change it. While I am working on this, I would like to change this property so that...

I have an application that among other things creates and e-mails as attachments (using VBA) invoices that are in the snapshot format. I have used this daily for several months while developing and tweaking the system. Today I handed it over to the "real" end user. For some reason, when she...

I have a datasheet subform that is powered by a non updatable recordset. I can't seem to design the recordset's query in a way to where it will be updatable - Is there a way around this? What I would like to do is have a user double click on a row in the (subform) datasheet and have it open...

I have a form where the user clicks his/her name on a listbox and then a (subform) data sheet is populated with their records. Ideally I would like to have the user double click a row in the data sheet and have this row's data open in a new form that the user would use to edit. I have asked...

I want to have a user be able to run a query and get the results in a data-sheet. When they find a particular row that has data elements that need editing, they double click that row which would open that row in a form that the user could edit and then save. Can someone please give me some...

I have a report that is based on the selection of 3 combo boxes. The SQL is a mess, but it works. Being that the data set is small, having this looooong SQL statement isnt that much of an issue. I need to further filter the results by date. I have two combo boxs (cboStartDate and cboEndDate)...

I have a calendar control that when you click it the first time returns the date as 12/30/1899. When you click it the second time it is right. Can someone tell me how to have the control return the date properly? Here is the code associated with the control: Private Sub ocxCalendar_Click()...

I am trying to filter a report based on combobox selections. When a value is welected for a combobox, that value is passed to the query, but when a combobox value is not shosen, it is supposed to pass a "like '*'" but it isn't. Can someone please have a look at this code and tell me where I am...

I am using Access 2002 and trying to use the ActiveX Calendar control - at design time it looks fine - but at run time, the control is just a white box. Can someone please tell me what I am doing wrong? Thanks, PDUNCAN Memphis, TN - USA When I die, I want to die like my grandfather-- who died...

I have a combo box named cboRCNo which is populated with a list of names. This is it's row source: SELECT tblController.RCNo, tblController.RCName FROM tblController ORDER BY tblController.RCName; I have a table of events (tblEvent) that has all of the data associated with an event - for...

I was asked to make an Access (2003) application to help keep up with what our regional controllers are doing. I have a form that they would use for data entry - they select their name, the location at which they performed a task, the date, comments, etc. I would like to have the selection...

I have a query with this in the field position: batch: DLookUp("[ZbatchNo]","tblZbatchNo","ZID=1") How can I add 5 zero's to the front (i.e. left) of this number? thanks Thanks, PDUNCAN Memphis, TN - USA When I die, I want to die like my grandfather-- who died peacefully in his sleep. Not...

I am trying to take the value a user enters with an inputbox and insert it into a table. Here is my code: Dim response As Integer response = InputBox("What was the Regional Total?", "Input The Total") DoCmd.RunSQL "INSERT INTO tblInvoiceTotals (RegionalTotalInv)...

Please help! I have a report that has some code behind it that updates a table when the report is colsed - it worked great until the other day.. now it doesnt update - can someone please give me a clue here is a code sample.. Private Sub Report_Close() 'save total amount Dim InvTotal...

let say I have 2 arrays - each array has 3 unique elements. example: arrayA("A", "B", "C") arrayB("1", "2", "3") I am assuming I would declare the arrays in a module ? I want to press a button on a form which would open a msgbox (calls function) that would display a random selection from...

Is there a module or function that will tell me if a query is used (or not used) by an application? I have several queries that I think I can delete, but not 100 % sure. I did document this app fairly well (I thought) but still have 40 or so queries in the window. I can only account for...

I have a simple access/vba application that imports an excel spreadsheet using transfer spreadsheet. Next it runs a query and groups records into smaller spreadsheets. It then mails each spreadsheet to a recipient as determined by a lookup table. Everything works well with this application...