Search results for query: *

Did you try CInt(left(column,6))?

This happens sometimes when a db is compacted and repaired. In a table you will sometimes see a row with #### in it. When this happens, delete the row and check the primary keys on the table.

Also, I found that in tables where the #### showed in the fields, that the primary keys on the tables could be lost. I would check the design view of a table after deleted the #### row.

Part of a way around this (which isn't fun) is keeping some of your tables in the back-end. You can make two back end dbs and ave the tables linked into a front end. This will minimize the problems with one db growing too large. The front end will need to be compacted and repaired regularly.

I believe that Access does not allow you to view the pictures how you want in a continuous form. A subform with the picture that is based on the current record the user selects works.

What is a book and a workeffort?

I agree that this doesn't happen just because there are three tables. This is from Access Help - searched for non-updateable: Data cannot be updated if: Query based on three or more tables in which there is a many-to-one-to-many relationship. Though you can't update the data in the query...

Sometimes it is best to split the query and make a subform. For example, the account name and ID would be on your main form and the address (from the other table) would be in a subform on the main form. By linking the subform to the form, you are able to stil utilize the join you want, but in...

It sounds like there are 3 or more tables in your underlining query. When this happens, Access likes to make your resulting recordset non-updateable. This means that Access will not let you type in a new record. Can you post the SQL for your query?

I have another question. I want to be able to view pcx images on an access form. I have a form with two subforms in it. One subform (lets call it sbfrm1) has a list of the images and their file paths (plus extra information about the images). The other subform (sbfrm2)is linked to the 1st...

I am trying to do something similar. I am working in Access 2003 and trying to print a report to another printer. I don't want the user to choose because they tend to forget. I have looked at the help files and microsoft's knowledge base, but when I try to apply them I get an invalid call or...

Goal: I am using code to make up an SQL statement that will append information to a temporary tbl (tblTemp) in a specific order. I want to base a report (rptlabels) off of the data in the tblTemp and keep these records in order (alpha, zip or numeric). Problem: The report will generate in...

I had the same problem on one of my forms - especially on 2003. I had to change my VB code from a refresh to a requery and the database stopped crashing. I haven't had a problem since.

About those parameterized recordsets, does the recordset have to be re-opened if the value of the parameter changes? How does that work? Mich

NewDate:iif([Since Date] is null,[Logged Date], [Since Date]) Mich

Why do you want to do this in the table as opposed to a form? Do you want today's date in the other field? Mich

I do not believe there is a way you can type the filenames into the listbox. I would think that making an invisible textbox and command button on the form and then some code would them would be the best way. I used the On-Double-Click event of the FileName listbox and put code that would...

Why aren't the tables related in your source query for the report?

set the recordsource for the listbox = SELECT tblInOutFile.FileName FROM tblInOutFile WHERE (((tblInOutFile.Input)=[Forms]![frmInOutFile]![Input]) AND ((tblInOutFile.Output)=[Forms]![frmInOutFile]![Output])); I made a form called frmInOutFile with two combo boxes(one called Input and the...

What is ParseSyntax doing? Can you include the code? Have you tried writing it another textbox instead of a label?