Search results

I am not familiar with Oracle but found the same problem when linking to an SQL backend. This link may help you too: http://support.microsoft.com/kb/318882

Hi, Does anyone know if it's possible to change the overall format of a form/report to a format saved using the Autoformat wizard. Rather than having to do it via the menu?

Try setting the control's Enabled property to False and setting the Tab Stop back to Yes.

Try this: strWhere = "[Group]=" & Me![Groups] & " AND [12 Follow-Up Scheduled] = False"

If it's a select query and the report is based on it then it should refresh as you open the report. If this isn't happening then I must be missing something.

You shouldn't need to open the query to select the data if you filter the query by looking straight at the form field.

By the sounds of it you don't need to see this query and there will be a way round it. Can you let me know exactly what the query is doing because above it says it just selects 1 record i.e. how/what is happening

Turning the echo off and on may work as follows: ...Code that opens the pop up form here.... DoCmd.RunCommand Echo False ...Other code here..... DoCmd.RunCommand Echo True NB: I would put the True line just before you exit the sub within the error trap just in case there is a...

I'm not sure I understand why you would want a pop-up form over a message box. If you don't want to see the message box why have it pop-up in the first place? (Sorry if not very helpful but I always like to try an understand the why first)

Try replacing this line: stLinkCriteria = "[Name] Like '*" & Me![txtCustomer] & "*'" with this: if Me![txtCustomer] <> "" then stLinkCriteria = "[Name] Like '*" & Me![txtCustomer] & "*'" end if if Me![txtpostcode] <> "" then if stLinkCriteria <> "" then stLinkCriteria =...

Is combo2 a dropdown with 2 or more columns and if so which column is the name column? If for example in the drop-down you have the ID as column 1 but hidden and the name column is column 2 then you would use this code: DoCmd.RunSQL "INSERT INTO tmp_ticket (ticket) SELECT ticket FROM...

Do you want to be able to filter by customer and postcode at the same time or just one or the other?

There are a few ways you could do this depending on the variations and how many fields you need to update. You could name the controls in such a way that you could then loop through each control and know which to update. Or you could add them all to an array. Or you could simply hardwrite it as...

If the value is a string then it should be as follows: DoCmd.RunSQL "INSERT INTO tmp_ticket (ticket) SELECT ticket FROM [tbl_ticket] WHERE assigned LIKE '*" & Me!Combo2 & "*'"

To export to .xlsx use this: DoCmd.OutputTo acQuery, "QUERYNAME", acFormatXLSX

If you use the DoCmd.OutputTo function then this should do it for you: DoCmd.OutputTo acQuery, "QueryName", acFormatXLS

You could always leave it as text and then have an Event Procedure on the OnClick that opens the file.

It's always setting it to red because you're telling it to with the following line: Me.WasteClass.ForeColor = RGB(255, 0, 0) WHat re you trying to do?

I maybe wrong but I don't think you can set conditional formatting without going into design view. I'll take a look later.

Something like this should work: In the detail section of your report under the OnFormat event put something like this: Me.[ControlName].FontUnderline = False and then still within the detail section but under the OnPaint event put something like this: Me.[ControlName].FontUnderline =...