Search results

Are you trying make a form from 2 tables? If so, using a query is probably the best way to go. It shouldn't give you an error. If you want post your db and I'll take a look at it for you. Yes, from two tables. Perhaps it's a bug of some sort in access whereby there's a limit on the number...

As in create a query and then create a form based on the query? That still gives me the same error. It needs to be a form since it's for data entry and I don't want users trying to do it using the datasheet view.

I'm trying to create a form from two tables but it errors out with: The wizard is unable to create your form or report because you chose too many fields; please try again with fewer fields. However, I can't reduce the number of fields and it's not because I don't want to. Is there another way...

Super! It worked a treat! Thank you for your help!

Yes I have done that.

In the example, it would have to be Field: Days Table: Table A Update to: val([[table b]!days]) since it is updating from table B to table A, but this results in an expression with invalid syntax.

Sorry for muddling the issue. Yes, the first was append and with your help that worked beautifully. Now I want to apply the same to an update query.

I have set the update query like this: Field: Days Table: A Update to: [table b]!days criteria: val("stringexpr") However, this changes the '0' back to '*'

How do I apply this to an update query? I have a field called days, which contains '*' as well as numbers. Can I convert them to blank or '0' like below? Field: Days Table: A Update to: [table b]!days criteria: val("stringexpr")

Ah right. Thanks for the info, much appreciated.

Where do I define what type I want it changed to? i.e. text to number, date, etc.

It's ok, I found out - set warnings to off.

I currently import data from a csv file into a table(A), which is then copied into table(B). In table A the fields are of type text since it's from a csv file. The fields in table B are also of the same type. If I change fields in table B to 'number' for example, then I can't copy the data from...

When I do that and then run it, I get "specify the table containing the records you want to delete" I open the query and add the field Table A.* running that I then get 'could not delete from specified tables'

I have two tables: Table A and Table B. Table B is wiped and reloaded with fresh data every day. The PKey is 'MAC address'. I'm trying to create a delete query which will compare the two tables and delete any records in Table A that are not found in Table B, but I'm having problems with the...

How do you get it to just update the records rather than append using Rue's method? (I get the message 0 records were deleted and 3000 were lost due to key violations)

Is there a way to automate this process without the need for user interaction (during the update)?