Search results

Hi all, I seem to have encountered a strange problem at work. I declared a public variable for user department. The user selects his department from a Log On form and if the password is correct, he opens another form with the department variable passed on in openargs. All of this works fine...

Hello everybody, I am over my head with this problem. I have a table that has details of staff at my workplace. I am using access to calculate the impact of staff movement on our budgeted salary. Thus, I have set up a system in which managers can use some forms to transfer, reclassify or add...

Hi all, Still new to VBA and I am trying to create a function that runs an append query like this: Dim strSQL_1, strSQL_2, strSQL_3 As String strSQL_1 = "INSERT INTO tblConsolidate([variable]) SELECT [variable] FROM qryResults" strSQL_2 = "......FROM qryOtherResults" ...so on and so forth...

Hello everyone, I have noticed something strange in my report. I have a few reports based on single queries where I use text boxes to calculate the sum of a column and a record. For column [Amount], I used =Sum([Amount]) so on and so forth. For a row, I use =[Amount]+[Expenses] to calculate the...

Hi all, I was wondering if you could use custom menu bar commands to open reports and varying the recordsource of the reports according to which command you choose. For instance, if the user wants to view a report for January, he clicks on the January menu bar button. And I do not wish to use...

Hi everyone, I have an interesting problem at hand. Assume that I have a normalized table with the following structure: Pk fkDept fkAcct Mth Details Amt But...in order to cater to spreadsheet users and also to allow data to be seen at a glance while being entered(as opposed to opening a form)...

Hi all, facing a little problem with my forms. Access gives me headaches everyday. Haha. In a continuous form, I have a delete button with the following code Private Sub cmdDelete_Click() On Error GoTo Err_cmdDelete_Click DoCmd.SetWarnings False If MsgBox("Confirm deletion of the...

Hi everybody, I have a form with its tabbed subforms' recordsource determined by the code: Private Sub childTvl_Enter() Me.childTvl.Form.RecordSource = "SELECT * FROM tblTvlInput WHERE tblTvlInput.Dept = """ & Forms.frmBudget.txtDept & """" End Sub This is to filter the huge data by...

Hi all, I have a table with the number of existing staff per department separated by their corporate level. I am able to use a query to display the number of staff per month(Mth1=ExistingStaff..so on). Since there will be staff changes such as promotions or new staff additions, I need to cater...

Hi all, I have a form (sub_Main) that opens and has an openargs value (Department) from my main form when user clicks on a cmd button. However, if I were to go back to my main form and click on another department the openargs value is not passed along. I have tried using Me.Refresh under...

Hi all, I have a main form with tabbed subforms(all based on different tables) where I want to display only the records the specific viewer is able to see. I know that I need to change the record source for the subforms based on the criteria of filter I want but somehow I'm lost in the syntax...

Hi all, trying to speed things up in the office but having a headache from this problem. Fairly new to access but learning more each day! We have two forms of information from our vendors containing ticket numbers and cost per ticket. Because of the difference in the format,it has to be...

Hi All, I have a sub form nestled in tabbed form which draws its contents from a query with a search criteria based on user input on another form. I find it funny that when I enter Me.Refresh into the child's on Enter event, it will only refresh the contents(sub form) if the user clicks on a...

Hi All, I'm new to access and I've a problem that has been hounding me. Right now, I am utilising a table containing the cost of air fare from one country to the next. It looks something like this: Origin Destination AirRateBiz AirRateEcon USA Japan 1200 800 Japan USA...