Search results

Try something like this in the onUpdate Event Forms(frmMainFormName).Form(frmSUBFormName).requery

Try changing the name of the initial file name input so that it is not the same as in the sub process ExportDelimitedText to Try changeing the same of the initial file name input. strRequiredFilename = InputBox(Prompt:=strMsg, _ Title:="File namer", XPos:=2000, YPos:=2000) then...

I'd try deleting it and replacing it. If that doesn't work then try doing the same but with a different lookup table to see if that is the cause.

Email Report (in body) Ignore the fact that there is a sub form. It is just data!!!! Much beter to use a function but here is one way. Use a cmd button to create the email call it cmdEmail1 EmailAddress is a textfield on the form strSalesDate is a textfield on the form of date entered If...

Try checking the cbo is not locked and is enabled (data)

Print reports from a form Slightly unsure of what you mean. Is it: The program should 10 copies of a report based on the record of ID 1 then print 2 copies of a (the same) report based on record of iD 23 then print 3 copies of a (the same) report based on record of iD 56 If so and the table...

Build the query Not sure if this will help but it may lead you in the right direction. This is for weekly billing to make sure it is always Mon to Sunday. This is from a website I have in a support application which bills on elapsed time in completed jobs. BillingDateDay =...

This depends on when the txtUserName gets the KH or LH. Is it OnLOad or does the user select it. In the Form OnLoad event if Me.txtUserName = "KH" then me.text7 = "keswick" if Me.txtUserName = "LH" then me.text7 = "lawrence" or Select Case Me.txtUserName Case "KH" me.text7 =...

Hi, Not sure about your code but I have got this working on a Network. Very easy to use and implement. I have a table which has a field a I use to select a report from (E.g. ReportName = 1, 2 or 3). My code open the recordset and then loops through it creating a new PDF for each record, but not...

You could try taking out the MyRS.Close but it doesn't look as though that is the problem. Can you post the underlying code for Add_POST or try this type of structure 'You open the DBConnection Set dbConn = Server.CreateObject("ADODB.connection") dbConn.Open(ConnStr) ' Then run the execute...

I have an input box which in the properties data input mask of the imput box has >LLL000LLL000LLL this allows 3 chars 3 numeric 3 chars 3 numeric 3 chars Can't remember what the rest of the options are but check access help.

Replace Dim MyRS As Recordset Set MyRS = CurrentDb.OpenRecordset("tblMain") with this Set MyRS = New ADODB.Recordset MyRS.Open "tblMain", CurrentProject.Connection, adOpenKeyset, adLockOptimistic (Recordset is not recognised)

If you have the Form and bind it to tblPerson you can then add the fields to display them. Then for the sID field have a combo box with datasource "Select sID, sDescription from Status" with 2 columns but column width 0cm;2cm and bound by sID (column1)

Can you post your Query as it is difficult to help without it.

I am slightly confused. Do you mean FK (Foreign Keys)? PojectGroup or GroupProject??? Get away from thinking left join etc access will happily with with SQL. Select employee from employees where (empoyeeID not in (select employeeID from Group where Group = 1) and emplyeeID in (select...

Table with field1, field2, field3. SELECT Sum([field1]) AS Expr1, Sum([field2]) AS Expr2, Sum([field3]) AS Expr3, Sum([field1])+Sum([field2])+Sum([field3]) AS Expr4 FROM TblTest1; This works fine.

Try this As a quick suggestion Sum([Field1]) + Sum([Field2]) + Sum([Field3]) as GrandTotal from etc etc I think Total may be a reserved word. The grouping is quite important as well.

The short answer is "Yes" but probably not very helpful!!! You have one query within another. But I need to check the actual sytax.

In the event of the tick box. On_Change have this If Me.TickBox = 0 then Me.Home_Email = "" ' set it to blank if unticked Else Me.Home_Email = Me.Work_Email ' set it to Work End if Me.Refresh

Just to re-iterate. The issue is not in a single control. The effect is report wide, with no number characters appearing. So a date "23rd October 2005" becomes "rd October". This can't be a font issue but is soemthing to do with the PC display settings for the printer. Remember the report is in...