Search results

Your method worked perfectly! I did have to remove the main form and move the navigation control into the MasterAccount form though. I hadn't realized that Access had automatically applied a filter to my sub forms on the tab controls so that's why I couldn't get it to work right away. Here's...

Hi! What I'm trying to do is update a subform based off a control in a seperate subform I have a question that I know is doable but is too tricky for me to figure out, so thanks in advance to the prodigy who can help me out with this headache :) I am building a tool to track our companies...

I have a report/quote where the users have a few option boxes to choose from and if they are selected, I want them to include those attachments when the email toggle button has been pressed, it sends the quote with the other selected documents included as well. Here is the code that I am using...

I gave that a shot as well, it looked like this: DoCmd.RunMacro "mcrQryUpdate Order Central Speeds" DoCmd.OpenForm "frmBegin Order" Me.[subfrmOrder Central - Access].Form.Requery End Sub But I still have to click Refresh after to update the subform.... :banghead:

That isn't doing it for me, I can't figure out why.

I have a main form with a few buttons to select which opens another window where the user orders products from. The main form remains open. When the order is finished they click submit and the data is appended to a subform on the main table. I can't quite figure out how to get my subform to...

Hah! That made me 'lol' That worked great though!!! Thanks so much!

Just to be clear here: I was hoping to the report by customer!

Not sure what you mean by wrong position! I'm still an Access Amateur.... I plugged in your code though like so: DoCmd.OpenReport "tblOrder Details", , , "Customer = " & Me.cboFilter & "'" and it came up with this error: Run-timer error'3075': Syntax error in string in query expression...

Firstly, sorry for all the questions today, the help is appreciated though :) I have a form that filter records off of combo, I want the user to run reports based off of the filter selected in the combo box. Here's the code I've been toying around with: Private Sub ReQuote_Click() Dim...

Thanks for the response! I tried that actually! It still was coming up with the same error so I found a way around the need for the filter, so I should probably delete this thread! I could use a pointer on how to do that as well :)

Hi there! I'm having some trouble with this code and can't seem to find the solution online. I have a combo box (cboCurrentCustomer) on my main form that I wish to filter 3 subforms. The combo box serves as a search box, filtering the subforms as you type. The first subfrom I'm testing this on...

Just tried it out and bumped into an issue: I have 16 categories/subforms that to have data entry enabled so here's the procedure: Me.subfrmCategory 1.Form.DataEntry=true Me.subfrmCategory 2.Form.DataEntry=true Me.subfrmCategory 3.Form.DataEntry=true Me.subfrmCategory 4.Form.DataEntry=true...

Awesome! That's great, thanks a bunch!!

Oh duh! Thanks CJ_London. Is there a way that I could modify the dataentry property with the button? Or should I just make a copy of my forms, one of each having Data Entry set to true and one of each having Data Entry set to false?

The latter of the two! So that the cells are ready to accept entry but with no existing records showing.

Lol over complicating things is the mistake I make 90% of the time! Glad you figured it out, good job.

Value 1: DateSerial(Year(Date()),Month(Date()),1) And <=Date()-1 Value 2: DateSerial(Year(Date())-1,Month(Date()),1) And <=Date()-366 Hmmm... I don't see why that's the issue, it clearly had the And operator. You could try: Value 1: DateSerial(Year(Date()),Month(Date()),1) Value 2...

Run this macro on one of the records in the New Client Form, lets say [Client Name]. New Client Form : txtClientName : After Update SetTempVar (CurrentClientID,[Screen].[ActiveControl]) OnErron (Next,) Requery () Refresh Finally set the default value for [Client Name] (in the Client Detail...

If I'm being ignorant here, feel free to chime in anyone but here's my suggestion: I don't have a way to try out but this might work for you, you'll probably have to tweak it a bit but I think it'd do the trick. Criteria: Between( (DateSerial(Year(Date()),Month(Date()),1) And <=Date()-1) And...