Search results

Yes the knock-on effects of a seemingly small change! I cut and pasted your code changes for this and the sequential number help you offered yesterday next to my code in a word doc and was able to work out the differences and similarities between the two solutions . This helped me to correct a...

@bob fitz, thank you so much! I can’t tell you how many cups of coffee I have drunk trying to sort this out! I am very grateful

Good morning all, Sorry to bother you again, yesterday I asked for help with sequential numbering using DMAX, it turned out that I had set the field type to text and DMAX stopped updating the sequence when it got to 10. Following the kind advice given, I reset the field type to number and...

@bob fitz, that is great, thank you, have formatted in the table field and this gives the answer I am looking for! I take it that the change of syntax is because my example was dealing with a txt field? once again, thank you

Hi @jdraw, it needs to be sequential to make sure that there is no wrong doing, think of it as an invoice number. The leading 0s are a formatting choice as Mentioned to @bob fitz, I have broken something by changing the field type to number, and with it set to text, it will only count to 10

@bob fitz, I have tried that, unfortunately, I seem to have broken something as the code doesn’t seem to Run with the field set to a number, it just returns 0

Hi guys, thanks for the info re txt & numbers, I can see the reasoning here. It is not a tax record, but will be subject to similar oversight / auditing, but not to the extent that an audit trail is required. If an item is missing, it will raise all sorts of questions, which is a path I would...

Hi Minty, as I said, my knowledge of Access is at best basic, but I have experienced problems in the past with autonumbers in that they are not always sequential, if a user cancels for instance, data is deleted

Ugh! Formatting removed and sequential number stops at 10 and returns 10 for each successive record

Hi Gasman and jdraw, the Field is set to short text and I have tried format in the table, form and report, separately and as a combination of some and all..... unfortunately, all to no effect. coincidentally, I notice that the code to increment the number appears to have stopped at 10, so I now...

Hi everyone, sorry to be a pain again, but I seem to be running around in circles...... I need a sequential number in my DB which should display in the report as a 3 digit number, i.e. 001. Searching this site has given me the code which will increase the number each time a form is submitted...

That is great, thank you for all of your help, duplicate records I can cope with!

As I said, I am a real novice so might need a bit more information, I take it any code would need to be placed in the form‘s VBA window (can’t see the need to use it elsewhere in the project at this stage) I have put the following In the on click event for a new button Private sub Go_click()...

Hi DBguy, Yes I can manually select the row in the table, copy and paste in a new row, all data, except the ID auto number (as expected) Copies

Hi Gasman, thank you for this, looking at the code posted in the last answer, it looks very similar to what I am trying to base mine on

Hey DBguy, no apologies necessary, it was my mistake..... removing the subject combo boxes will work, but they are fairly important

Hi, yes I had worked that one out, but thanks.... the trouble is, it is a fairly important aspect of the project

Sorry, I misunderstood, I thought you were suggesting Manually copying and then pasting

Hi, if it was just me working on the database, I would probably do as you suggest, in fact, I would probably use Excel, but, there will be quite a few people using it, so it needs to be as robust as possible.

Msg box states: Method ‘Value’ of object ‘Field2’ failed in debug, the line of code highlighted= clone.Fields (f.Name) = f hovering over the highlighted code, a box indicates the error in the f.Name = “Emotion” which is the combo box with multiple selections. Hope this helps - thanks