Search results

um...your end format doesn't match mine. I have: ......& Format(RightNz(DMax("[rmanumber]","maindata")+1,1),2),"000") Obviously, 'rmanumber' is the field from my table, 'maindata', but I seem to have extra bits in mine. What am I changing? The last '2'?

Yes, please post a sample as this is the kind of thing I'm also looking for (Also-hopeful-but-probably-not-as-much-as-Vassago!)

Sorry, one more quick question. The function works exactly as I need it to now, with the following revised code: Private Sub cmdSend_Click() Dim WordApp As Word.Application Dim strTemplateLocation As String strTemplateLocation = "MY TEMPLATE LOCATION" On Error...

Ah, found it. My references were not properly defined...doh! Works now.

Ok, I've just hit a snag and would greatly appreciate some advice. The above code works perfectly for me, and opens up my template, replacing my pre-defiend bookmarks with the field data as required... ...however, I have just tried to embed my code into an existing database (the small database...

Thank you, MStef! That is exactly what I need!

Thanks all, I finally decided on - and succeeded with - setting up a Word template with bookmarks for the fields that were to be replaced. A button was then added to the Access form, and the following 'onClick' code added: Private Sub cmdSend_Click() Dim WordApp As Word.Application...

Thanks for the explanation, FoFa. I think this crept in whilst I was doing some testing on my AddRecords form (i.e. creating false records just to see if my coding worked). I'm guessing the only way to reset that counter is to physically wipe my table and reimport the data then?

Ah, I see what you mean. If I alter my system date to October, the new autofill still works, but still adds 1 to the number of the last record, rather than starting at 1 again for the new month. Thank you very much for looking at this for me, incidentally, it is greatly appreciated!

Thank you , Rak. Will get reading!

Um...at the risk of sounding dense, how do I do that? I can check my table and it just lists the records 1 to 113, missing out 90-112, as stated earlier.

Ah-ha, thanks Michael; I knew there was a way of doing it. Have also just found GHudson's wonderful mousetrap example, so am considering using that to force the user to either save the form, or undo their additions.

Thanks, Rich. I have tried compacting the database, but it doesn't seem to clear the problem. I don't absolutely need sequential numbers, these are only the numbers that Access assigns to each record that gets added; it's just irritating when searching records to have a jump from record number...

Hi all, and apologies for starting a fresh thread about this, but I can't find exactly what I'm trying to achieve via the search function, although I'm hoping it's just something simple I'm missing. I have a small database that allows the user to click on a button to go an Add New Records form...

Sorry if this isn't the right place for this, but it didn't seem to fit in anywhere else. I have a simple database, which pretty much now works as I want it to. The only element I really needs to get working is some way of producing - at the click of a button - a Microsoft Word document...

Hokay, firstly my apologies if this is the wrong subforum, but since my question revolves around the behaviour of one of my forms I guessed the thread should go here. I have a very simple little database which I use to log RMAs (Returned Merchandise Authorizations). The database consists of...

Hokay, so I have a very simple little database which has been written to make my job a little easier by logging the details of certain calls. Everything on it seems to work fine, but there is one piece of strange behaviour that I just can't fathom... I currently have 89 records stored (these...

Ok, I've got my combo box [comboname) on my combobox selection form (formfilter) bound to my query (coredata query1) in its RowSource. The query forces the combobox to list all data from the Name field in my main record table (coredata), uniquely by using the code: SELECT DISTINCT...

Ah, yes they are both bound to 'coredata Query1'. Since the combo box takes its data from the query, I'm assuming it is setup correctly, which brings me neatly to the question "What the hell should the form be taking data from?"

i think i almost got it to work but it goes January october, november, december, feb, then its normal it does 1,10,11,12,2,3,4,5,6,7,8,9. err i dont know why its doing that It's doing it because computers sort numeric data logically (so sorting goes 1, 1x, 2, 2x, 3, 3x, etc., where x is any...