Search results

I cant use a pre-amble or post amble. Here is why. What I have is a form that I am inputing data from one of 3 reports that were printed with barcodes. There is a main form with 3 tabs each with a subform. After scanning a barcode (order number) I want to scan a second barcode to move focus...

How would I print a barcode that would represent the keystroke Alt-Q? I have a barcode font of Code128 and would like scan a barcode that would send the keystroke Alt-Q to the PC. Any ideas? Thanks vmon

Is there are command or snipit of code someone could share to unhide all columns in a datasheet subform when a form is opened? Thanks, vmon

I have tried this and it is not working. Is there a settin that would prevent it from updating as records are filtered? vmon

boblarson, Would you have a short example of the Excel Object Model that uses a filter you could share? Thanks, vmon

This sounds like you suggest sending data to a report and then to Excel. I would like the data to go to Excel from the filtered datasheet but only the records being viewed in the filtered set. I have not been able to get a filter to work with the OutputTo. I know it works with the openreport.

I am taking this as "no can do" based on response :( . Is there maybe a different approach to what I am trying that might work:confused: thanks, vmon

Is there a way to output a filtered set of records to an Excel spreadsheet. I can send a filtered set of records to a report using this: DoCmd.OpenReport stDocName, acPreview With Reports(stDocName) .OrderBy = strSort .Filter = strWhere .FilterOn = True End With Is there a way to do the same...

I have a mainform and subform. I have a subtotal in the footer of the subform that is displayed on the mainform. I am trying to have the sutotal reset based on the exclusion of records using the right click filter menu. Is this possible? How? Thanks, vmon

Got it I can set the Sort/Group By and then in the On Open event I can change the group level. Here is what I did. Select Case Forms!frmMfMRP1Rpt!OptPrintBy Case 1 '* By Item ID Me.GroupLevel(0).ControlSource = "ItemId" Case 2 '* By Location ID...

I have a report that I want to sort two different ways depending on user selection. I am having trouble getting an expression to work inthe Sort/Group By on the report. I setup an if like this. Iif(OptSort = 1,Item, Location) Can I put an if statement in the Sort/Group By? thanks, vmon

I have the page number in the Page Header section of a report. I want to print a report footer that shows some totals along with the page header but the page number is resetting to 1 when the report footer page prints. Any ideas? thx, vmon

I am trying to update a column where item id's are equal. I know how to do it in tsql but am not that familiar with how to get it done in vba. Could you help? Here is a statement. strsql = "UPDATE A SET A.DemandStdDev = StdDeviation " & _ "FROM tmpBaseStock A INNER JOIN " & _ "(SELECT ID_ITEM...

This makes sense but I am not sure how to put the syntax. I am using A2k in an ADP with SQL Server backend. I am using ADO. This is what I have right now. Set rst = Forms!frmMainForm.RecordsetClone rst.FindFirst "[IdRecNum] = '" & Forms!frmSubForm!IdRecNum & "'"...

I have a mainform that show a record from a table. On that main form I also have a subform datasheet that shows all of the dates in a column from the same table as the main form, sorted asc. I want to select/highlight the row in the subform datasheet to show where the record on the main form...

I have a Mainform and Subform. The subform is driven by 2 combo boxes that filters records in subform. If I right clik in the subform and "filter for" a value then try to use the combo boxes to filter the combo's do not work. I have to use one filter method or the other. Is there a way to...

I have checked the box to not show the database window but the user can hit F11 and display the db window. Is there an easy way to prevent this? I would rather not disable the key. vmon

I am using SQL Server backend and have compiled my ADP into an ADE so the user cannot make changes to forms, reports, macros. Is there a way to also limit them from getting to the database window where table data can be changed? I used to use Access Runtime and now am not sure how to lock the...

I have a mainform and a tab control with 4 subforms, one per tab. On the mainform I have a checkbox that opens another form that contains calculated summaries from data on mainform and 4 tab controlled subforms. If I use the <CNTRL><TAB> keystroke to move from subform to mainform focus moves...

I am using XP with SQL 2k . I have a combo box on a subform that I want the rowsource to be populated by the following statement. The procedure works if I enter an ID but does not work when called by form. The code is on the mainform. Any ideas? Private Sub Form_Current()...