Search results

Please I'm not looking for a final answer- just a head into the right direction

when I get statements that are too long, I usually just start the filtering process earlier in the process with an extra query- if you are able to.

Hello- it’s hard to find something in the forum if you don’t know what to look for. I need dlookup in reserve I have a user check out the data before they run a report. I can’t automate it because they must come to a decision on how the data must be fixed. Each situation is unique I have a...

Thanks! I thought it was just empty space... stretch marks, if you will. Thanks- I was just wondering. Will compact in the future.

I have noticed if I open an empty database, and import everything- tables, forms, queries, reports- the "new" database is significantly smaller then the old one- yet it is the same thing. Why? what am I losing? Am I losing something important?

thanks! So, I guess it's just out of the way, and not completely invisible. Thanks~

Yea- I ended up doing that. for future reference- is it really "invisible" or just out of the way?

I have a form opening up in the background. Its job is to check a value every 2 minutes and trigger a chain of events that will shut the database down if I want to make repairs. I want the form to be invisible. I have changed it's properties to visible= "No" I have never had a form invisible...

I am working on the same thing. You just want to have a confirmation to be sent to ..Everyone? just a few people? Please explain. For example, I want to send an email out to who ever is going to receive a file that day. Not everyone will get a file every day. So to clear up confusion, I...

Never mind- it doesn't work. It bugs out.

bubble gum and string well- I could not find the syntax I wanted so that when I picked from the drop down, it would change the subform, so I but this on the oncurrent of the subform : Me.RecordSource = "A_" & Forms![Activity Authorization].[Unviewedlist] It worked this way. It sits there...

oncurrent?

nope. I tried : Me!Actsubform.Form.RecordSource = "A_" & [Unviewedlist] Access referred to actsubform as a "Field" again. It is possible that the information from the combo [Unviewedlist] is not being "Remembered" because I am referring to the subform? I am trying to take what is...

I take it that you see the data populated in the text box. Have you tried saving the record after the text box is populated?

I have a form that, depending upon a combo box in the header, will change the recordsource of the form to whatever table is listed in the drop down. I have no problem with that. Unfortunately, my form has a continuous subform that shows all entries on that table for easy viewing. I can change...

I'll give it a shot. I think the front end back end is a great idea I have everything shoved together Thanks

Also Tried=- help!!!! Call Forms("72sortersubform").Command4_Click It says it can't find my form. I double checked, the name of the subform. Command4 is NOT private.

Btw I already tried : me.sortersubform.Form!command4 I get "Compile error, Expected ="

I would like I have a form and a subform. I would like the control on the main form, when it's done running, to activate a command button in the subform. Subform is 72sort subform the command button is command4 I have tried so many things I don't remember what I have tried anymore. Can...

Same prob I have just posted the same question below. I have not reached the same level as you (in curruption)- 1 record so far- but I don't want to be where you are. (sorry, but I've been there, so I know how fusterating it is) I have access 2000. I have only the records currupting. I...