Search results

So thanks everyone for all of your suggestions. Unfortunately none of them worked. For what ever reason this control simply will not activate a BeforeUpdate event. What I ended up doing is using the OnEnter event and then a SetFocus to move the focus to the next control. Clumsy way of doing it...

I did. Still is not firing.

Sorry I was not clear. StartDate is the control (field) that I have set the BeforeUpdate code on. I have entered a date in the StartDate control (not in code) but in form view and then moved to the next field. The code does not do anything.

I put a stop in front of the line of code in question. Then I entered a date in that field and moved out of the field. Nothing happened. I have this very same line of code on a command button and it worked perfectly. I just can not get it to execute on the BeforeUpdate or the AfterUpdate. When...

Ok I may be having a brain fart or something but I have put Stop where you said. I was expecting a dialogue box to pop up asking me to go to debug or something like that when I changed the value in StartDate. It did not so I was not in the VBA Editor and could not go to the immediate window. Am...

I am not sure if it running. I would guess not. The value is a numeric value which is the ID of the underlying form I put stop in but then I am not sure what to do next. I have not done this before It is there, but it was typed in rather than turning on an option.

I changed the field in question to StartDate Here is the full code on the BeforeUpdate event on the StartDate control Private Sub StartDate_BeforeUpdate(Cancel As Integer) Forms!pfrm_WSPositionWage!WSPositionID = Forms!pfrm_EditWorkStation!ssfrm_WorkStationPositions.Form!WSPositionID...

I have actually tried the BeforeUpdate with the same results. I have also tried this on several different controls in the form (Not just the Date one) again with the same results. I did use copy and paste with the code

I will try and keep this simple as the database and form structure are quite complex. I have the following line of code Forms!pfrm_WSPositionWage!WSPositionID = Forms!pfrm_EditWorkStation!ssfrm_WorkStationPositions.Form!WSPositionID I need this to work on the AfterUpdate event on a...

Ok this one is a bit weird My client wants to print a report when there is enough records to fill a page. Let me explain There are two tables involved, a tbl_Clients and tbl_ContactNotes which is a sub of the clients table Data entry takes place every time there is a conversation with a...

As did I. And the code above is supposed to work. But I keep getting a variable not found error. I believe it is having trouble with the word Ribbon in quotes but I am not sure what other name the ribbon would go by.

Actually this won't work for my application. I need the ribbon completely hidden. If it is minimized the user can simply maximize it and I do not want them to be able to do that. But thank you for your Idea. I am sure I will use that in another project down the road.

I have done a lot of reading on this and have seen that DoCmd.ShowToolbar “Ribbon”, acToolbarNo Should hide the ribbon. Instead I get a 'Variable Not Found' error. This should be simple. Am I missing something here?

That worked perfectly. Now I just have my other problem. My db loads ok but if I open a form in design view I can not get to the properties of any of my controls or fields. I right click on them, properties is an option (not greyed out) so I click on properties and nothing. Not sure what is...

So I made a quick test and discovered that some of my code is considered unsafe and the only way for i to run was to set the macro security to low. The only problem is it gave me no indication as to what part of my code is unsafe. ANd even after turning the macro security to low i could not get...

Hello everyone. I have been developing databases in an Access 2003 environment for a very long time now. The problem I am now encountering is people have access 2007 or 2010 and for my databases to work I have to uninstall their version of access and install 2003. My question is on how to...

The query works fine on it's own, with hard coded parameters or with the form equivalent. It is only when I run it in conjunction with the module that I get the error and only when the form elements are in the query

Hello everyone I am attempting to use Bob Larson's export to excel function on a button on one of my forms. The query I am basing the export on references values stored in a form. When I run the module i get an error To few parameters. Expected 4. Coincidentally the query has for parameters in...

Re: export table to excel in runtime I have done a similar thing. My code reads Call SendTQ2Excel("qry_ExportCompanyList", "Company List") I get an error Too few parameters. Expected 4 Any suggestions

Run-Time error 2162 A macro set to one of the current field's properties failed because of an error in a FindRecord action argument Hope this helps