Search results

Not to sure how to do this. I have a customer form which I obviously enter customers details on. There are times when we do a small cash sale and want to bring up the customer called "cash sale". Can i do this with a button? as it is always the same record we use for this purpose. It...

I have 2 subforms on the main form

How would I go about doing that?

Hopefully someone can point me in the right direction. I am trying to highlight a matching row in a subform from the main form. I have a popup form (mainstockform) with a subform (addinventory) to enter existing products into the db stock, when entered it updates another subform (currentstock)...

Not sure why this seems so difficult for me to fix. Have a field OrderDate which carries dates of sales. I am trying to group the date into days Currently I have OrderDate SaleAmount 6/6/08 100 6/6/08 150 6/6/08 120 7/5/08 130 7/6/08...

Thank you very much have it working perfectly now. I was nearly there but just needed a little guidance.

Hope someone can point me in the right direction. I am trying to refresh a form from another form, here's the scenario. frmCurrentStock has all of the current stock and from time to time I need to add new stock items. I have a button that opens up a frmAddStockItem for me to add a new stock...

Thanks, guess I did understand it after all. I couldn't seem to make this work using a lable but could using a text box, so I suppose its not possible then using a lable is it? Thanks

I don't understand what a logical test is? and where it goes. Sorry for my ignorance.

Can't seem to make that work as the lable is on a report called invoice and I cannot seem to get he reference correct using the following Private Sub Check231_Click() If Check231 = -1 Then warrantylbl.Visible = True Else warrantylbl.Visible = False End If End Sub

I am trying to make a label either visible or not on a report via a check box on a form but cannot seem to get it right. Private Sub Check231_Click() If [Check231] = -1 Then Me![Invoice]![warrantylbl].Visible Else Me![Invoice]![warrantylbl].Not Visible End If End Sub Any ideas what I am doing...

Can anyone help me figure out why my access 2007 forms are slow? There seems to be about a 1 sec delay in the field updating from 1 field to another. Thanks

Perfect, thank you.

Hi I am trying to print an envelope from a customer form. I have a button that brings up the correct envelope report with the customers data in it but I want the envelope report to print without preview. I am using Private Sub Print_Envelope_Btn_Click() strReportName = "Envelope"...

Thank you for taking the time to look my question. Hopefully I can be pointed in the correct direction. I am trying to stop duplicates in my customer table, the table is as follows CustomerID PK Salutation Surname Address1 Address2 Address3 City PostCode Phone Cell I have the surname...

The lines that are highlighted are as follows (all with ++++) Public Sub Trans_Window_Deactivated(ByVal Wn As Window) ++++++Call Window_Deactivated(Wn)++++++ End Sub Public Sub Trans_WorkBook_DeActivated() ++++++Call Workbook_DeActivated++++++++++ End Sub Public Sub...

Thank you very much for the speedy reply. Not sure what has gone wrong but I am getting VB errors come up. The form does open but with errors The errors are under Trans_Functions and the error is Compile error: Can't find project or libary. The errors come up as follows Public Sub...

Hi can anyone point me in the right direction. I have imported an "Act" database to access, all has gone somewhat well. I am stuck on a problem with linking to existing excel files. I have an file attachment table called Fileattachments with the following fields ContactID CreatedOn ExcelFile...

This is not going in a table, this is in the lable at the top of the report showig the report name and the curent week date. Hope this make sense.

I am looking for the lable to be something like April 20th - April 24th (today) in otherwords current week starting Sunday (April 20th) to today's date (April 24th) Thanks