Search results

The form is opened via a button containing: Private Sub cmdAdd_Click() Dim strLinkCriteria As String strLinkCriteria = Me.txtDept DoCmd.OpenForm "frmAddNew", , , , , acDialog, OpenArgs:=strLinkCriteria End Sub This opens my pop up form which has Rich's validate data function in the...

I inserted DoCmd.GoToRecord acDataForm,"frmName", acFirst right behind accmdDeleteRecord. It's not a perfect solution but I'm wondering if any problem might occur? Today is a day when I need more than the usual cups of coffee...

Pardon me because I do not understand.. The form is a popup which I opened as a dialog window. Would setting focus outside still work? The form's recordsource is a table so how would a query come into place? I'll try the bookmark on preceeding record and see if it works. Thanks for the quick...

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

Hey..didn't know tab on change could be used. Seems noticeably faster but I need to test it over the network. Had tried using gotfocus, lostfocus, blah blah... That would solve the problem of the refresh too, I think. :) Thanks a lot!

Refresh There is also an issue of refreshing the data automatically if changes are made..I have to click on another tab and return to the page where changes were made to see the refreshed changes...Been bugging me for quite some time..

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

Okay..figured out how to use flag field for adding new staff(without relying on another table) but I'm still trying to figure out a way for reclassification of staff. Because I need to be able show the user which month the changes has taken place and also to calculate total headcount for that...

May I know what is a flag shield and how do I implement it? Still new to access and learning much here! Tables are used so that I can use the data collected to calculate the eventual increase in salary due to the new staff or promotions. But if I can do it simply with a flag shield (whatever...

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

That worked great! =) Thanks uncle gizmo!

there's no way that i can circumnavigate this? i've tried using macros to set values and it doesn't involve closing the active popup window. but i don't think that's the best way right?

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

another note I am currently using a query with a criteria based on a textbox which gets its value from user's input on which department he is from. I'm trying to cut down the number of queries used...So a dynamic flter would be best, I think. Any suggestions would be fine!

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

Wow,thanks for the help! I'll try to get this to work with what Iwant. Thanks!

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