Search results

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

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

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...

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 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()...

I have a form that is used for data entry and it does an add new record after and update. When the user clicks the X to close the form I want to prompt them to complete record yes or no. If they say yes how do I cancel the click of the X and put focus back in a text box. I have been trying...

I have a sum calculated on a main form that is set from a text box in the footer of a subform. I have trained people using forms to use the right click and filter by selection for narrowing records in a datasheet. Problem is the calcualated value on main form is not being updated with the sum...

I am setting focus to a combo box and would like the value in the box to be selected so a keystroke would clear value. Just like the tab key does. thanks, vmon

I have a column that has data I need to sort on. The column is a text field and contains numbers and letters. Could have 1 to 3 numbers in start and 1 or 2 letters follow for half the list and 1 letter in start and 1 to 3 numbers follow. Like this. 10A 19A 20C 2B 2C 402AL 430B 482CL a2 c2 j1...

I am having same trouble. I get ODBC -- Call Failed. [Microsoft][ODBC Visual FoxPro Driver] Error Reading File. (#104). The linked table connections work for a while and then just stop with the message above. vmon

I am creating a text file (csv) and writing text to the file. Is there a way to export text without having my data enclosed in double quotes? Here is what I am trying. Open "c:\john.txt" For Output As #1 Write #1, Trim(rstExport.Fields("RecTyp"), _...

I want to set a varaible to an object but I want the object name to change. I have 3 fields called: field1, field2, and field3 and want to use a varialbe to reference each adding a counter to the end to identify which object. Here is what I have tried. A and B are just numbers. Any ideas...

Output to excel 5.0 vs 2000 specificaiton I have the following code and I am getting an error that says there are too many rows. The export is sending about 17,000 rows. I am using A2K - ADP with SQL Server 2k backend. Problem is Access uses Excel 5.0 as specification when outputting for...