Search results for query: *

Hello, I have this mostly down but was wondering if there was a primer or information on how what steps to take to create an access form that is like an application main form. That is acts as though it is not an access form but rather an application. I have trouble with the form still being...

I was wondering if there is any way to change the Regional Options Short Date Format from within VBA for Access? Thanks, Lewis

I have an application with a tab control. I have placed a button on the first tab to preview a report. The button is appearing on the second tap of my TabCntl when I switch tabs. I do not know how this came about but how do I fix it? Thanks bunches as always!

I have code running in a Private Sub where there are Public variables in the GENERAL section. The code runs and opens a custom dialog box that allows the user to enter data. When the dialog closes I want to pass the data to the variables in the original module. For the life of me I can't get...

I have a main report that I am using along with two sub reports to collect all the data. Main Report Group 1 Group 2 Detail 1 Detail 2 SubReportDetail 1 SubReportDetail 2 Group Footer 2 SubTotal SubTotal SubTotal SubTotal Group Footer 1 SubTotal SubTotal SubTotal...

I have a main form that is used to create a record and after insert the focus moves to the subform and I can add records associated to the parent form record. How can I put a button on my subform that will allow the user to start a new parent form record? This would mean that the user could...

I have a form that is the "Main" form for the application. I have a startup icon associated and works fine until I generate a report. I am hiding the "Main" form when the report opens and showing the "Main" form when the report closes. This way only one item is...

Hello, I am running a timer event that takes the focus from the active control. I have the following code to determine the active control at the time the focus is taken away. ' Determine the name of the "Active" form at the time of the error. Dim getfrm As Form Dim...

Does anyone have a quick and dirty (or not) primer for taking an Access 2000 database and placing it in a multi-user environment. I have a Database that if fully functional, formally normalized, all the controls are programmed just the way I intended. The app is finished. How do I or what can...

I am working on an error handler in an Access 2000 function. I am fully capable of creating error handlers in private subs but I am having trouble with this error handler in a module function. When you are using the "OnError" sub on say a form you can identify the error, and use the...

I have a crosstab query that does this: Expr1: "PD" & Weekday([Date]) this allow the column headers to be "PD1", "PD2" and so forth. I need to write a function that does the same thing but I have a separate table to determine the period? How can I return a...

I have a Microsoft Access 2000 report. The report is intended to print on a Genicom 4940 lineprinter. I have gone into page setup and told it to use the specific printer and a specific form for that printer that is setup under Printers>File>Server Properties where the form type was setup and...

Is there any way to "Right" justify a numeric column in a List Control? As Always, THANKS BUNCHES!

Can you utilize the "FindFirst" method with multiple arguments for the search criteria? For example if you want to find a record based on two criteria such as rs.FindFirst "[CNUM] ='" & Forms!Frm!CNUM & "'" AND "[Item] = '" & Forms!Frm!List73 &...

Is there any function to determine what "WEEK" in a year a date falls into? I would like to have a calculated expression that would assign a number to a date based on which week of the year it falls into. Any help is greatly appreciated.

What is the best way to trap a duplicate record error when the user is entering data? Is the FORM: "OnError" property the best using Dataerr = 3022 or is it better to look for an existing record using the FORM: "BeforeInsert" property? Thanks,

I have a form that is used for data entry. I am doing an error trap for the FORM "OnERROR" event. The error being trapped is when the user enters a duplicate record. Private Sub Form_Error(DataErr As Integer, Response As Integer) ' In the event the user tries to add a...

Hi, I have an SQL statement that contains a DLookup as follows (pasted from the query builder): DoCmd.RunSQL = "SELECT CPUMstr.CPUSN, CPUMstr.CPUMfg, " _ & " CPUMstr.CPUModel, CPUMstr.CPUAsset, " _ &...

I am writing some code for a spreadsheet that will need to search each sheet in the workbook. I am not terribly familiar with the Excel object model or syntax but have done tons of VBA for Access. I will need to start at the first worksheet in the workbook and search, then move to the next...

Hi, I have a spreadsheet and there are basically four formulas that I would like to be able to change at runtime. open sheet. ask user which formula to replace? let user input replacement formula (portion) There are four VLookup formulas that can be anywhere in the workbook. I only need to...