Search results

Ah, yes, the old Peter Principle! That's a real danger. The "dirty little secret" in all this is that while I have achieved some notoriety with this project, there are whole areas of Access DB development that I haven't even touched on with this project. Like handling financial transactions for...

I would like to take this opportunity to convey my deepest thanks to the many contributors to this forum who have assisted me over the last three years with so many minor and major Access development problems and hurdles. I work for the Australian Red Cross, in administering a community program...

In tblClients, ClientID is the primary key and is Autonumber. In tblClientGender, ClientID is the primary key and is set to Number. The table is editable, but I need to automatically provide the ClientID number in the tblClientGender table with the ClientID that is in the other table...

Hi. This seems like such an elementary question it is almost embarrassing, but I need to get it right in my mind. I sometimes need to add a new field into client's database, but I don't want to keep on just adding fields to an existing table. So I want to create a table with a new data field...

I thought it would be something like that. Thanks!

Hi. I want to be able to record the time that yes/no fields are clicked to a True state. I will have several of these in the form I am to build. How do I do this? I want the time fields visible but not editable, and to record the time when a yes/no field is clicked to indicate an event has...

Thanks for that. I'll study it and see if I can make it work.

Let me see if I can explain my problem. I have a crosstab query that displays information by month in columns as new data is added to the underlying table. For example, as may 2017 data is added, the crosstab query will create a column May-17, and as June data comes into being it creates that...

Ok, I have written the code and placed it in a module called "CallTodayValue". I have added some additional code based on two fields that override any other considerations in the evaluation. I would appreciate someone just checking this to see if it should work: Function CallTodayValue() As...

Thanks for that. I will try this and see how I go. By the way, yes, I have tested every case in the expression and it works flawlessly (so far). Such is the blissful ignorance of the self-taught! :rolleyes: The expression evaluates a range of conditions to determine whether a client needs to...

It may not be the most perfect syntax, but it works. How would you deal with this then? How would I convert it to VBA? Just as a standard If statement but as VBA rather than as field expression?

I have a rather complex expression in an unbound calculated field on a form. This started out much simpler than it is now, but as more and more conditions have been added to the expression it has now become too unwieldy to manage as an expression. I am thinking of converting it to a Select Case...

Thanks for that. Another good reason. Yes, I find that my relationship diagram is a bit onerous to interpret now. It would be good to be able to subdivide the diagram into different views that could help to organise and track relationships a bit better. Is this possible?

Could you add a field with phonetic spelling? This could be added to your secondary table rather than a sound file, and can be related to the tblNames via a foreign key. You can have an unlimited number of "styles" for each "Name". Sound files will take up an enormous amount of data...

Thanks for that. Yes, I was wondering if it is the referential integrity aspect that was the important reason for establishing standard relationships. I hasten to say that I DO use the relationship builder for all tables that I think will need to be related. So, what changes then if tables are...

I have a staff rostering system I am developing, which is based on a simple table with a date field and other fields such as StaffMember, Position etc. It works fine for entering rostered days individually. However it would be good to be able to enter roster information for rostering on regular...

Just a question. How important is it to define table relationships in the Table Relationships area? I often find that for individual object purposes I change the relationships anyway to fit the requirements of the particular query I am building. It seems that establishing formal relationships...

Yes, good idea. I will use a test database to try to analyse the problem in stages. I will post a demo database with the problem if I can't solve it that way.

Did that without success. I have another Date/Time field which is set in the query as CallDate: Date(). This works, but if I try that in the other field it sets the value as a non-editable value.

Yes, I can add records, it is just the default value in the table field that is not populating into all records. I bring up the datasheet from the query and the "Mood" field is empty. I can edit the field in each record, but I want all records to be populated with the default value when the form...