Search results

1) One way to do this is open the report itself and pass the filter in the OpenArgs using DoCmd.OpenReport In the report's open event, do something like: If Me.OpenArgs & "" = "" Then Me.FilterOn = False Else Me.Filter = "FirstName='" & Me.OpenArgs & "'" Me.FilterOn = True End If...

Sorry, I just got your message. The original code was under the assumption that you were only dealing with fractions. For instance, the original post (now deleted) was misleading in how data was stored in the table. I think you stated that there were no whole numbers and that the data would...

Again, using the cstr() function will typecase whatever is inside it. use cstr([Your textbox name here]) in your query You should post your query's SQL for further assistance.

I am not familiar with the binair datatype. Could you possibly mean binary? If that's what you mean, I'm going to assume you mean it's really boolean, using true/false conditions or (0 and not 0) - not 0 is usually represented as a -1 for true. To make a number a text you typecast it using...

More than likely when you added a new button to a form, you used Access's command button wizard, which automatically generates the VBA behind the form. After the button was created, you more than likely renamed or deleted the button without deleting the code. Unless you create another button...

Dirty checks to see if the record has changed since it was last saved. Try doing a Me.Refresh before the if statement.

<To readers: xaysana updated the attached database> I have renamed your combo boxes and added two different events with conditional statements, which I assume is what you're looking for (a updated combo list when flipping through the different records). I commented out whether or not you would...

Please don't update the original code for actual changes made. It makes it hard to follow the thread if you do that. Instead, post the new code and in the original create a link to that post (if needed).

If you can do SQL Server, that is, if it does not hurt your network performance then you should do it. It is a much better database, as great as Access is for small-scale, desktop, ad hoc databases, it is not as robust as SQL Server or any better designed database.

Depends on how you want to write the algorithm. If you wanted to do it week by week, it'd be easier. Doing it by any 5 date span would be a little more tricky.

I performed the function on a database that was 7MB to start with. The table that was going to have Random Numbers eventually had somewhere around 450,000 records. There were no errors, but the database is 1.7GB. I assume your database was larger than 7MB to start with and that Roy is right...

Comments on Indexes: If Access handles indexes like Oracle - I believe all the common databases use the same approach - then what the database does is store index information in a metatable. This metatable is usually in the data dictionary cache (I believe). Indexes are good because they spare...

You dont need to exclude those fields because they will be updated with the next query anyhow. The querybuilder makes it relly easy to append fields with the same names.

You might want to post your final solution for other users.

Have you tried just Fn + Break?

Format([Date Field],"yyyymmdd") So your SQL would be similar to: sSQL = "SELECT Format([Date Field],""yyyymmdd"") INTO [New Table Name] FROM [Table From]" Where "Date Field" is the name of the field that's a date, "New Table Name" will be the name of the table created, and "Table From" is the...

1: make sure qryName is a variable with the actual query name 2: remove the parentheses; DoCmd.OpenQuery qryName Also, make sure "Some Table" is the actual name of the table or query you are copying from. If [Some Table] is a variable, then your SQL should be: sql = "SELECT * INTO...

Are you sure your attached the correct database? I am not seeing any Fixed Assets forms and no form has two combo boxes.

Keith is correct. * - evaluate any number of characters or symbols (or lack of) ? - evaluate a particular character # - evaluate a single numerical digit [] - evaluate a character in a range (ex. [A-Z] checks for a character in the alphabet) [!] - evaluate a character not in a range (ex...

Yes, please share. I was under the assumption that you had already created an ODBC driver and established the connection. So the fault was not in the table itself? I'm curious to see what was wrong and how it could be fixed.