Search results

What about this? Could I have the IsOversized checkbox control where the record is saved? I'm thinking that I could have two tables, one for each size. But I'm not sure how I would have the MapIDCode detect from which table to get its next incremental number. I know not. Anybody... . . . . ...

:(

Progress OK, so I've managed to get Dmax to work. I've posted the barebones of the database below so everyone can see what's going on. The problem now is, as you will see, the user can only put one record in the table before the lame automatic code generation process that I made fails. this...

i've read quite a few posts now on incremental primary keys, and why it may not be a good idea to do it. i think i'll use an autonumber field as the primary key "in case" something ever goes wrong, and I'll use an automatically generated MapIDCode for the order (more like location) of the actual...

i'm sorry, i guess my answer sounded pretty lame. I see what you mean now. I'm not sure. Maybe you could explain why you need users to tab into the first field on the first record but not on any others. p

i think that when you say the data is erased, it is really just saving the previous record and giving you a new record to add. check the table that the form is based on and you'll see that your data is in the table. yes, there is a way to prevent a field from being tabbed. you can right click...

if i understand you correctly i think your problem is simple. keep or recreate the table you want to use, then use that table for the row source property in the Interest combo box. try to delete the button that opens the form and then make a new button to open the form. this will eliminate any...

I posted this in the tables forum (I think yesterday), but after searching other posts, I'm certain that it is a form issue. And, I think my solution will involve the Dmax function, but I'm not sure. Anyway, here's the posting: I have a table that acts as a catalogue for the company's maps (its...

I think the setting is in the form. Check the form's properties (make sure it is the form's properties though and not the properties of an object in the form. I've gone crazy with this mistake before.) Then look in the Data tab at the following properties: Allow Edits (set to No if you...

I like to use macros to control how stuff opens from a switchboard. You can easily create a macro with the OpenForm Action and then set that action's data mode to Add. You also have to specify your form in the Form Name property. You can then open the macro with the switch from the switchboard...

on second thought, I think that you should just have one table. Once you make sure that both tables have the same fields you can copy and paste records. Then, you can manipulate the data the way you want. You could then have a field for the type of data shown as a combo box with a value list...

you could also keep the two tables that you have and create a query that gets all the records from both tables path

I have a table that acts as a catalogue for the company's maps (its a land surveying company). I have many years worth of maps that are in desperate need of being organized. What I'm trying to do is order the maps according to an automatically generated MapIDCode. The autonumber feature in the...

It would be nice if you could join the sides of adjacent text boxes, to make them "stick together" and have them auto-resize. There is a can grow and can shrink property but it only changes the height. I have the same problem with the appearance of addresses in my reports. The city is always a...

thanks a million, i had the same question and Tal's solution worked perfectly. I would add only that if your field name has spaces in it you need these [] around the field name in the code. For example: start code ************************************* With CodeContextObject...

Dave, I think I've figured out a solution. I made a query with all the fields from the 2 tables that I need. Evidently Access "knows" that the records go together. So, instead of the users seeing the time book table I'll just let them see and print this new query. I can leave the Job Name field...

I'm sad to say that I'm using Access 2000. I tried to use the conversion tool to convert the database into an Access 97 file, but it said that there were errors that prevented the conversion. So, I don't know what to do. Any suggestions? I can post any code you need.

in the table set the field size to decimal and the format to general number. how bout now?

if so, go to the form and right-click on the control for that field and choose properties. there is a setting for decimal places under the format tab. this setting could cause your problem. is this the problem?

is the problem that the decimals do not appear when you write to the table from a form?