Search results

I have a code question. I have a checklist form that user initial steps as they complete them. Once a step is complete it gets lock so someone else can't go in and make changes. Because rework is sometimes needed I added a command button that unlocks certain steps. So I have this code on a...

Yes I have code in the on open and in the on load if I remove it all works like it should. I need to turn the code back on in steps to see what the problem is. Thank you Jon

So I have a field on the main form that is called mainID which is an auto number and gets updated when you start a record. This field is set as the master link. On my sub form I have a field ID which is set as the child link. So when the form opens there is no data in this field so I get a...

Ok so I got my sub form setup and working. I have it setup as a continues form so it will show all the time someone has had to rework it. However it always has a blank record at the bottom. Can this be turned off? Can't find it

No that is not it entirely. But I do see your point. I just want to use 1 field on a tabular form to act like a simple post it note if you so that if the record set that they are currently looking at has had 1 or more reworks. If that makes sense. But I think I could add it to a table and then...

Sorry I should add that I can get 1 of the 3 fields to update I just can't figure out the code for all 3. Code is {forms![form1].memofield = (me.name) } that will put the name in the meno field. I have tried AND with the other 2 fields but I won't work. I also can't get it to add to it. Every...

I have a main form1 and I have a field called rework and this field is setup as a memo field on the table. I have a command button that when selected will open a second form (pop up) and there are 3 fields on this pop up form "date" "name" and "reason" and a command buttom on the pop up called...

I think I got. I believe my relationships were setup wrong between the 3 tables. But don't get why the qry would return the correct date but not the form. But I believe it's now working. Thank you for assisting Jon

Correct. It is set no

So if I run the query and I get 1 record in the query grid. Than that would mean the query is good and working. The control source for the form is set to the query. I have removed all the code in the open event and on load events so the form should open and display the data right? Mine does not...

Well it's funny you ask that question. It was opening the form with the fields and no data entered. Now it's opening the form competely blank. I believe I have an issue with the tables that the query is using to open the form. Still struggling have not given up just yet.

I have tried it set to Yes and no either way same results

I have data in the table and when I manually run my query it returns a table with data. But when I open the form it's blank? I can't figure out why Please help

Can you change access 2010 so that when you use the wizard to create a command button it uses vba code as did 2007 instead of using macros?

Working on a form and when using the wizard to add a command button or a txt box the wizard gives it a funny name like command989. Im wondering why? Where does this default come from and why is the number so high? There is no way anywhere near that number of command buttons on this form. Does...

That might work. A pain to setup but once set its done. jon

Fair enough I get it. Yes the tables have the same limits. What I'm trying to do is build a checklist that service people follow doing a task. I'm using the tabular form which is really nice and works great. So I have a 10 page tabular form with lets say 256 fields spreed out into 3 seperate...

plog - thats it I was jioning them wrong. Thank you for the help. have a great new year jon

I know that the cap is 255 fields in a query. Is there anyway around this?

would it be possible to just send it to you? I would rather it not go out to all without alot of scrubbing? I can scrub if you perfer. jon