Search results

Would Format(time_1 - time_2, "Hh:Nn:Ss") work for you?

I dunno if this is what you are trying to do, but try out this for you RunExcel. This finds the last row used and pastes the data from D1:F1 below it: Option Explicit Function RunExcel() Dim MyXL As Object ' Variável para conter a referência...

You are welcome:-) For future reference, Access uses Null to indicate blank values, unlike Excel, which uses "". Your IIF statement can also work as follows: IIF([state] Is Null,"PA", [state]) But Nz is made for this purpose.

Use the Nz function instead. It replaces null values with a value specified. If it is not null, it will return the field value. Ex: Nz([state],"PA")

Have you tried formatting the date from the table (using Format function) in your query's condition? For example: WHERE Format(date_time_field,"mm/dd/yyyy") = Format([Form_Field],"mm/dd/yyyy") You might not need the Format around your form field, depending on its format.

Can you tell us what error you are getting? Obrigado.

You should be able to use OR in your WHERE clause. For example: SELECT * FROM table WHERE policy1 = 'DI' OR policy2 = 'DI' OR policy3 = 'DI'

Sorry, I misread the post :-) You can also use Me.form_field.Locked= true / false, but this applied to individual fields.

Have you thought about using the "Pages" (webpage) option of Access? You should be able to create webpages straight from Access, just like creating a form. The security is a different issue though, which I am not too familiar with.

Hello, I am trying to connect to an Oracle database using ADO instead of DAO. I am connecting using ODBC, and can connect just fine, but I want to insert the records retrieved by the recordset into a table in my access database. Can anyone tell me how to accomplish this without looping...

I deleted the first post after I realized you meant a outer condition. Thats good to hear. Access is a great tool, but I really hate Jet :mad:. I am used to Oracle servers myself, which you can simply type: condition_item(+) = condition. Have a great weekend!

You mean something like an outer condition? You can try creating a new field as: IIF(tbl_Licence_Potential.GJ = "08/09","Y",Null). Then, for whatever you are using this query for, the records that are applicable from tbl_Licence_Potential will have a 'Y' for this column. Or, you could also...

Not that this is the safest way (since any user can simply hold Shift while entering the db to unlock), but have you tried something like: If Me.password_field = "password_string" Then DoCmd.OpenForm "form to open" Else MsgBox "Password incorrect" End If Hope this helps.

The problem is probably since the text box is feeding the query a string value, when the actual table value for Yes/No is stored as a boolean, even though Access calls it Yes/No. Try changing the "Format" to "Yes/No" under field properties of your text box/combo box in your form (select field...

I am not 100% clear on the second part of the question, but as far as updating any values greater than 864, have you tried using an update query? For example: "UPDATE table_name SET RunningSum = FlexiMax WHERE RunningSum > FlexiMax;" And from what I understand on the second part (deficit)...

Yes, thank you both. That must have been posted right before my thank you post.

It depends on the data type. If it is a number field (integer, double, ..), then you do not need anything around them. If it is a string, you need apostrophe ('). If it is a date field, you will usually need # around it. You can find out what type by checking the table where you are...

Thank you very much Banana. :-)

Thank you for the quick replies. I mean if I have a table linked through ODBC, and I create a query through design view. Am I using DAO or ADO to connect and retrieve these records?

If I understand it correctly, you are using a combination of ID2 and amount1 as a determinant of a unique record. I believe you will have to use two queries for this. You could create one query that groups by ID2 and amount1 and has a third field with count(ID2 or amount1). This first query...