Search results for query: *

Hello, I have the following code and it works great. I was wondering if it's possible to tweek it a little further to add [R_FOUND], which is a date/time field where it is null. Private Sub LOCATION_BeforeUpdate(Cancel As Integer) Dim varADDRESS As Variant If Me.NewRecord Then...

Can someone please tell me what I'm doing or not doing wrong? I have the following module: Option Compare Database Option Explicit Declare Function ShellExecute& Lib "shell32.dll" Alias "ShellExecuteA" (ByVal _ hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal _...

Hello, I have a form with a combo box and two text boxes. Depending on the selection the user makes I want the cursor to move to one of the text box. Action (combo box) Current_CHL (text box) New_CHL (text box) Add - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > > >...

Hello, I'm fairly new to VB. I have the following code. It's stopping the user from going forward (adding new files) and thats it. The error is not popping up of the cursor is not going to the field. All I'm getting is a Microsoft Office Access Error "You can't go the the specified record."...

Hello, I have the following code attached to one of my text box so that when the user enters a tech_ID in the L_TECH # text box the tech's name automatically poplulates in the L_TECH text box. What I didn't think about is if the person doesn't have a tech_ID. Does anyone know how I would...

Hello, I have a crosstab query showing the amount of new units recorded on a montly basis. I have the following code to show it: Expr1: Format([L_FOUND],"mmm") Does anyone know how I would change this to show new units recorded bi-weekly? Thanks.

Hello, I am not able to print from my databases. I think the last time was like two weeks ago. I was on vacations for two weeks, and when I came back my office was moved. IT came in a hooked up my computer and everything was fine. Yesterday was the first time I tried to print a report from...

I found the code on the FAQ on how to Disable/Enable the Shift Key. Does anyone have any suggestions on how I call the sub to disable the database. I have a a transparent button to Enable the shift key. But I don't know how to go about Disabling it. Thanks.

Hello, I'm using Microsoft Access 2003. I have a report with 5 sub-reports. I tried to insert a 6th one and I received the above stated error. Can anyone tell me why this is happening and how I can go about fixing it. Thanks in advance.

Hello, I have a database that tracks leak issues for my company. Everytime that an issue is not resolves, a work order is created. At first I was using the Autonumber field as a PK and to generate the workorder numbers. If the leak issue wasn't fixed right away, I would just copy the leakID...

Hello, I have the following code attached to the subform in my main form and it works fine. Private Sub Location_BeforeUpdate(Cancel As Integer) Dim varLocation As Variant If Me.NewRecord Then varLocation = DLookup("[Location]", "LEAK FOUND TABLE - 2"...

Hello, I'm not sure this can be done, but I will give it a try. We have 10 regions in our company. I a form that lists all the systems in all the regions. What I would like to do is, when the user click on the button to open the systems listings from the main switchboard, where they click on...

Hello, I have a huge problem, and since this is the first time that I'm trying this, I can't come up with a solution. This is my situation. My boss wanted me to create a database, that asks for the username and password because he wants to know who is in the database at all times. I did this...

Hello, I have a form and I have found that the users are not following the proper procedures when adding new records, and in turn they edit existing data. I came up with the following solution to force them to follow proper procedures. I have the following code attached to my add new record...

Hello, I have seen a number os threads that deal with flashing labels and text boxes, but have found none close to what I want to happen. I have a text box, that is a result of a calculation. The magic number has to be 63.99, that the highest that the calculations can be. As soon as the the...

Hello, Hello, I'm not really sure if this is the right place to post this question. I had posted in another forum and someone directed me here. Every time I Compact And Repair my database, I get the following message Table 'TempMSysAccessObjects' already exists. There is an Ok button and...

Hello, I'm not really sure if this is the right place to post this question. Every time I Compact And Repair my database, I get the following message Table 'TempMSysAccessObjects' already exists. There is an Ok button and a Help button with this message. I click the Ok button, and my...

Hello, Can someone tell me what I'm doing wrong, or please help me. Private Sub cmdOK_Click() With Forms("frmADD_LEAK_FORM") .Filter = "COMMUNITY= '" & Me.COMMUNITY & "'" And Forms.frmADD_LEAK_FORM.frmADD_LEAK_SUBFORM.Form.LEAKID = Me.LEAKID .FilterOn = True End With...

Can anyone tell me what I'm doing wrong in the following code? Private Sub cmdOK_Click() With Forms("frmADD_LEAK_FORM") .Filter = "COMMUNITY= " & Me.COMMUNITY .FilterOn = True End With DoCmd.Close acForm, Me.Name End Sub I hightlighted where the error is...

Hello, I was told that it is possible to filter a form and a subform from another form? I was told that I need to set the forms!Formname.Filter="Query String" and then forms!formname.Filteron=true I have a form (frmAdd_Leak), that has a subform (frmAdd_Leak_Subform), they are attached by...