Search results for query: *

on opening a form in vb.net, how do you show all items in a list box. What is the sql statement?

Trying to bring in Exel Spreadsheet, but statement tries to find file in D Drive when I am in O Drive. Statement reads as follows: DoCmd.TransferSpreadsheet acImport, 0, TableImported, TableImported & ".xls", True, ""

I am not sure how the data for a check box is supposed to appear on a report. The check boxes on my report show nothing even though many have a check mark indicating a yes answer on the form where the user has checked them. Do I need to put code behind the report to make the check box field on...

I am on Forma. I open formb and have both forms in view. I run a query in formb that will update the table that is the source of formA. I put the following code in the close event of formb. When I hit the close button on formb I get the message that another user has updated the record do I want...

I have a mainform with 3 subforms. How do I tab to a SPECIFIC FIELD on the 3rd subform after leaving the 2nd subform. I have no trouble tabbing from subform to subform but I cannot get the code for moving from specific field on a subform to a specific field on the next subform. Also, I have...

I want to set the values of all the fields (records) in the table to spaces or 0 accordingly. Can I do this with a single line of code or do I have to address each field in the table separately to update it's contents. I am hoping there is an "initialize" piece of code to do this...

I took the next example off this site but is does not work. Can someone tell me how to string 4 keys together to make the stlinkcriteria work. I do not know what double quotes go with what single quotes and so on. Dim stDocName As String Dim stLinkCriteria As String stDocName =...

How do I either format or create an input mask that uses only year as valid input. The user does not want to enter month and day on the form. Do I change the table or the form or both and what does the format or input mask look like to accomplish this. At the table level, is the data type...

We are using Briefcase to keep Access tables in sync between laptop entries and original tables on the network. We keep getting this two way merge message when we try to update via Briefcase that says some laptop table entries were updated at the same time on the same date as the network data...

My access drive is mapped to another site. The access application transfers a table to another database when the application closes. It works fine from my home-side, but the when the user closes the application at a remote site, run-time error 3044 messages appears on their screen. How can i...

I need to be able to set listindex of combo box so first row of its source is always showing when form initially opens. What is the format of this access statement?

I need to be able to create a button that will zip a database so the user can email it. Only zipped databases can be emailed from our systems. I need the code that will accomplish this zipping for an access database.

I have a field called DateOfIssuance, it is mmddyyyy. I need to sort it so the date range can span from one year to the next. ie: mmdd must be greater than May 15 and year must be calculated as (year + 1) with new mmdd less than May 16 of the next year. How do I create a new sort field for...

I need help checking a date field with this criteria: The date must be greater than May 15 of the dates current year, and less than May 16 of the NEXT year. Checking dates between years throws me.

I am bombing in access97 because of this code while trying to append a record to a table. DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append What is the...

odd size label, print problem, avery 4001-610, measures 4.5 in. by 10 in. Two(2) sections to label page, 6 labels in each section. I have good code to skip and duplicate labels, but not to print 6 labels, skip 1 inch, print 6 more labels. This avery label page is one column.

Tab from subform to main form after record added on main form gives this error message "You Must Be On A Record With Data". I click on OK. After I manually go back to the main form and then to subform again, this message does not appear when I tab from the subform to the main form...

Subform problem. After adding new rec on mainform. I try to tab to subform. The tabbing makes a message appear. This only happens after I have added a new record. This message appears. (After I answer ok to following message, subform is ok). message reads: Microsoft access can't find the...

I have the query depending on data from a form. ie: 1. field on form = strSuffix criteria in query: strssuffix = [forms]![myform]![strsuffix] 2. field on form = street criteria in query: street = [forms]![myform]![street] There are null values in some of the street data...