Search results

Not too certain of the above text, but this might work: In your query, under the field Responsible, in the criteria put <>"SRG"

A simple and quick way is: Private Sub Form_Open(Cancel As Integer) 'Check number of records in Record Source of Chart If DCount("[Field Name]", "Table/Query Name") > 0 Then MSChartName.Visible = True Else 'Don't display chart MSChartName.Visible = False End If End Sub...

Not at all! It's all a learning curve and we're all in it together, whatever the level.

Not knowing your tables or forms, I hazard this guess: Make a copy of your db and test the following: Point 1. a)Try entering the data straight into the table, if the error comes up then it something to do with your table. b)Copy and paste the code that opens your form, this will give more...

In the DESIGN VIEW of your table, click on your Date field and under the Field properties; General Tab you'll see the property Default Value. Type in Now() in there. That will put the time and date stamp on each new record.

Can you be more specific? By the sounds of things you should set the focus to the text box and set the text. ie. txtMyTextBox.setfocus txtMyTextBox.text = "Text"

Try: stLinkCriteria = "between [date]=#" & Me![Text3] & "# And [date]=#" & Me![Text115] & "#" Btw: You should give your objects useful names for example: cmdOpenSentMemoForm; txtFromDate; txtToDate. Then if another developer picks up your code then they will know what is going on!

On the Open Event of the form why don't you check the Record Count of the query. If it brings back 0 why not set the Chart Visible Property to False.

Go to Tools\Options on the Edit/Find Options Tab un-click: Record Changes Delete Documents Action Queries. You will need to do this for all your users.

Which version of Access is it? Try: =Forms!Stock.frmStockSubform2.txtMaxUnitCost.value or =frmStockSubform2!txtMaxUnitCost.value or =Me.frmStockSubform2!txtMaxUnitCost.value

Does anyone know the dll I have to reference to use the Regular Expression object? Many Thanks

Hi Guys, I'm using this connection string below. strConnection = "Driver={Microsoft ODBC for Oracle};Server=ServerName;uid=UID;pwd=PASSWORD;" But I keep on getting this error.: [Microsoft][ODBC driver for Oracle][Oracle] Any ideas?? I have created a DSN with the same parameters and using...

Call me crazy, but why are you doing this? Is your data corrupt?

Try this, copy and paste into a new column in your query: Time_Logged_Out:Format(DateAdd("s", "[Login Time field name]", "[From Start Date field name]"), "d mmm yyyy hh:mm:ss") You can remove the d mmm yyyy if you want.

Looks like you're going to have to write a function for this. Look up Bubble Sort on here or the google.

Sounds like you need a Bubble Sort on the value returned from a DateDiff.

Sent you a private message.

In a query, add your Audit table. Display the two columns Audit and Audit Cycle in the design grid of the query. Then, copy each of the below into two new seperate columns: Days_Until_Next_Audit: DateDiff("d",Date(),DateAdd("m",[Audit Cycle],[Audit])) Months_Until_Next_Audit...

1.Open the your main form. 2. Right click over the subform to bring up the menu window and select "Subform in New Window" (at the bottom) - this will open the subform itself in a new window. 3. Then bring up the properties box for the text box/control that references the field [MEDRECNO]. 4...

Hi, Used that link. But unfortunately it isn't completey working. My app comes up with a request for the default driver. Has any one got complete code for an Access DSN-less connection to an Oracle db please? Thanks