Search results

Here's a copy of my database. I've stripped it down to only include the details you need. Hope you can help.

I wish I hadn't started this. It only works if the button is only pressed once in a 24 hour period. If it is pressed again on the same day it reorders them based on the last number in the second table. i.e. Day 1 input is reordered like this 0001 anderson 0002 bentley 0003 collins Day 2 is...

Hi, Finally sorted it. I had to use: Counter = Dmax("FamNumber","YourTable") - 1 And it works fantastically. Thanks again for all your help.

I'm sorry if this sounds noobish.. but how do I set it up so that the last number is stored in another table.

Ahh, one problem. The number starts at 1 for each day which is not the desired effect. What I suppose I need to do is have the FamNumber field get it's number from another source on a different table but I don't know how to do this. For example: Day one has FamNumber 1 - 20 20 needs to be...

Hi, I tried it out on a copy I had, works perfectly. I did have one problem and that was that it applied the reorder to the whole table, what I wanted it to do was just reorder today's records. So I just created a query which showed all today's records and had the counter code point to that...

Thanks Wayne, I will try it when I'm at work again on Monday. :)

BTW, I can't get wayne's idea to work, not really sure what I need to replace in your code. My table is called "famgram_input_table" the number field is "FamNumber" and the name field is "Surname" Where would I place this code on a command button? ;)

Hi, Sorry it's taken so long to get back to you all, btw thanks for all your support. Atomic shrimp is totally correct in that the messages may be referred to by the people receiving them and that the system which sends the messages has no connection with the database. Each person receives a...

Wayne, The database does not actually send the messages, it is just a way for my staff to log them. Your second example looks like it should do the trick. BTW I used "count" & "name" only as an example in the post. The actual fields on the form are "FamNumber" and "Surname" Atomic, yes.

Just thinking, Maybe there is a way of assigning the numbers to the messages once all messages have been entered for that day. If so would that be hard to incorporate (for a beginner)? fingers crossed

Maybe I didn't explain myself... here goes. I am in the navy and whilst I, and my colleagues are away at sea we receive messages from our loved ones. each message must be sent in alphabetical order each day. I have created a database whereby the person sending the messages can input that...

Is there a way of changing records to align themselves in alphabetical order and change the DMax counter numbers assigned to those records to match? i.e. (I use the DMax counter on the forms "before insert" event) can I change the following (read in two columns "count & name"): count -...

Sorry Bob, I thought this might have been a common problem and would be sorted without the need for code. And I was v tired at the time. Here's the code for the module: Option Compare Database Public Function RequiredData(ByVal TheForm As Form) As Boolean 'Check that all TextBox...

I'm having problems with validating data on a form. I created a command button that sets focus on the next page of a tab control. The validation code is within a module and is called for in the Form's before update event. The problem is that the correct error message appears from an "On...

Wow, that was quick Bob Fantastic work :)

Hi (again!) I am getting there with my new database, however one thing eludes me. I have a tabbed control <TabCtl0> with 4 pages which are related to the first page. Two of the pages only contain a subform (nothing else). I have a "Next" button which navigates through all the pages using the...

Thanks, I found it about 2 mins after I posted this thread. :eek:

Hi, I'm trying to make a form available to users so they can input data without any other data being available to them. So I created a data access page, which works but when opened it shows the first record and the other records are navigable by anyone. How can I make it open at a new record...

Hi, After reading all about Autonumber and what you should not do with them, I am building my DB from scratch. The problem that I immediately hit upon is as follows: I created a table with a text field and want it to increment from 1 (so when the very first record is started the number 1 is...