Forms :: Invitation Form - Database For Handling Of Events For Clients
Apr 22, 2013
I am trying to build a database for the handling of events for our clients. I therefore do have four tables named "Client", "Invitation", "Invitation status" and "Events". The table invitation includes an own primary key and the primary keys from the tables "Invitation", "Invitations status" and "Events" as so called secondary keys. I have now built an ongoing form, based on the "Client" table.
This form has a list field which includes the upcoming events. All our clients are listed below this form (as it is an ongoing form). After the name of the client I do have a drop down field calles "status" (source is the table "Invitation status" where we can remark if the client is invited, has confirmed his attend and so on.
The problem is now as follows: I am able to put in the status of a specific client for an event. The result is saved in the table as wanted. I am also able to change the status and this will be saved in the table as well. What doesn't work is that if I want to change the event, the status doesn't change. This means that if a client hast the status invited for event X he has the status for all events, which shouldn't be. The aim would be that if I am changing the event, the status also has to change.
I am trying to create a database that will record the availability of volunteers for different events.
So far, I have used access to create an availability table, that contains fields for event, date, name, shift 1, shift 2, shift 3.
I now want to create a form that will filter this table for a given event, then layout the form so that names appear down the left, date across the top, and then the shift 1 to 3 fields (which are yes/no fields) to appear in the body of the layout.
This is so the organising team can quickly enter this information (received by phone, email, fax) into the database. I have had a go with subforms within subforms but so far drawing blanks.
I have a requirement to send a email to individual clients via my access database 2003 . I am using the email address of the client in the current open form . I then created a query using the id to filter that particular client, this query then becomes my record set.The content for the email is held in a .txt file , On my c drive . Every things appears fine however the fonts that I select in the .txt file are not being use in the actual email body. I created a word document with my preferred fonts and copied and pasted them into the .txt file but on sending the email the selected fonts do not appear.
I have attached a demo of what I am trying to do . To test enter your own email in the email address field of the form . Note the .txt file is on the C:/ drive.
I have a client database that has null values in issue received, there are as many as ten issues per client. What I need to do is make a list of clients that have only two issues outstanding and a list of clients that have three or more issues outstanding. There are two tables that are connected correctly. The client table(one) and the issues table(many).
Ok, not sure if this is even possible or where to even start..
I've got a form that has all the info for a client, eg.. Client First Name Client Last Name Client Hours Client WE/CS/EE Client Day And Times Client Phone Client Comments
Begin Date & End Date (2 boxs) on there for date input..
and what i'm trying to do is limit that any date entered between begin date and end date, it'll check and make sure there is only ever 20 clients on any 1 day..
i thought Datediff would be the way to go, but then again how do you get it to search each day and make sure theres only 20 clients on there..
how to deal with errors specifically with error "The Microsoft Access database engine cannot find a record in table".Database which I'm creating have table Products, which contains information about products. Most important information in this table is if product is VATable or not. I decided to define product names in invoice table that database can recognize products and calculate VAT in invoices if product is VATable. Problem starts if you have new product. When I add new product in invoice it counts VAT but when i go to next record I receive message mentioned above. It doesn't allows me to go to next record or save record.
I was wondering is it possible to make it that access allows to fill invoice, informs about new products only when i have finished adding all products in invoice and than gives opportunity to add them to product list?
I am developing a claim tracking database that tracks dates of events that occur in the course of processing a claim; such as, Loss Date, Report Date, Estimate Date, Payment Date, etc.
With this table structure there is a many-to-many relationship between Claims and Events, but, there will only be one of each event per claim. Is there a better way to set up the tables to enforce a 1-to-1 relationship?
I was planning on creating a form for the Claim table with a subform for the Events joined on ClaimID and fkClaimID, but that would allow users to create more than one set of Events per claim, if that makes sense.
I have a database in which people add little bits to different fields as they go. For instance, person 1 puts in appointment, person 2 verifies info for the customer, person 3 checks the customer in, person 4 takes their money. What I am trying to do in a form is track the time when each department accessed it, and which user. I can do this on a new record, but for some reason, I can't get the event properties to work correctly on my form. I have a field for each department set aside for when they update their part of the record. What I am trying to do is, when the record is updated, having the time autopopulate the field.
Example:
Appointments enters |DATE OF APPT| |TIME OF APPT| Appointment timestamp should = time()
Reception enters |PULL TAB#| |CHECKED IN y/n| Reception timestamp should = time()
Cashier enters |AMOUNT COLLECTED| Cashier timestamp should = time()
All of these fields are on the same database (I have 2 linked tables: Customer demographics and appointments linked one to many by account # for the customer), and obviously, there's a lot more to it, but this is just a short example of what each department will enter. Appointments starts the appointment, so their timestamp will work, as they are starting new record. However, all of the following departments will be adding to this appointment record. When the other departments open their form with the fields in which they will be filling out, I want it to timestamp when they update the record as well as inserting their login "currentuser()" into the "updated by?" field for each department. For some reason, when I put time() into the event portion the field, it doesn't work. I tried it on dirty, on exit, after update, and it just doesn't update. Am I missing something?
I have a form that has a field called Project Name where a user types the project name. We have certain abbreviations we use for a building making it hard to search in the future.
I know we can set the autocorrect option on Access Program but that will effect all MS applications.
Is there a way to have a certain field or for have these autocorrect options?
The database XXXXX_20061018.mdb contains the form Frm_XXXXXX. Currently this form does not show data after it has been opened. infact of the Me.FilterOn = False. so please give me some idea how to solve this problem
We use the before update events of text boxes for error checking and normally that works exactly the way we want it to. The focus remains on the text box until valid data is entered. However, there are a couple of situations where we would like to be able to release the user from the constraints. One being a button that clears the form and the other being a button that closes the form without saving the date.
In these situations the action of the before update events are just an irritant. Imagine a user who starts to fill out a form and just started entering a date, when he realizes he doesn't need to enter the record. He clicks on the close button and then is forced to complete a date for a record that will never be saved.
If there were just some way of determining what event triggered the before update event, i.e., determine that it was the close button, we could tailor the before update event code to handle these cases. Is there any way to do this?
We realize we could avoid this by postponing the error checking until the record is saved, but we want to provide the user immediate feedback on data errors.
I am trying to update values in an unbound text box based on a selection in the combo box on the same form; however whilst I am easily able to display the information for the first selection the values do not update when I change the value in the drop down.
My DVD library database I have a memo field which has the description of the movies.
In some cases, like my tv show records, I have a lot of data because of the episodes and episode descriptions.
I'm currently displaying this data using a split form with the datasheet on the left
I must use a small font in the memo field in order to display all data.
I could use a larger font and simply scroll but I'm looking for an alternative.
I've even thought of creating a hyperlink filed and point to the movie on IMDB's web site. But when I click the link nothing happens even though I copied and pasted the link into the field.
In my database I have module that checks if tick box is True and then closes all the forms and kicks the user out of the database. However in most of my forms, there is a custom Save command in the On Click of cmdSave button and the Form_BeforeUpdate. The save requires certain things to be true so naturally if a user has made a change to a record, the form won't allow you to close it if you haven't saved your changes or undone them.
Is there anyway I can get my module to bypass certain events in the form?
I have a parts order form (FrmORDER)with a list of parts selected stored in it. e.g Part #, Part Description, Qty, Price etc
I also have assemblies stored with the same detail that are composed of individual parts.
What I would like to do is
Open formA if I do a single click (to select a new part or assembly) Open formB if I do a double click (to open the contents of the selected assembly in the order form
It would seem that the following series of events occurs
When the user double-clicks a control other than a command button: MouseDown → MouseUp → Click → DblClick → MouseUp
Hence I can't actually open formB with a double click unless I remove the single click event.
I'm creating a database for a music store which also does music lessons. In the header I wish to display the number of lessons that are taking place each day, the number will be dynamic as the number of lessons vary from day to day. I obviously have a table with all the lessons that have already taken place, as well as lessons that are taking place in the future.
I've attached the header (isn't the final version) as an example.
I have a form which has been in use for some time now, and works extremely well for all users; as part of a recent update to that form, I added a few events to various controls; most of them are message box prompts to remind the user to do something, but one is automatic entry of text into a memo field when another field is updated, and it is really this last one that is causing an issue.
There is a command button on the form which has an embedded macro, created using the wizard - it is probably the last, or one of the last few buttons that have a macro as opposed to VBA.
Essentially, when this button is clicked, I would like a duplicate of the current record to be made (thus giving it an Autonumber ID of its own), and if possible I would like this to be done without triggering any of the after update events on the form. Is there a way to disable these events and copy a record in its entirety, re-enabling the events at the end?
I have a database with a list of clients, their enter and exit dates. I need to do a query that will count how many clients we have on a specific date. Keeping in mind that clients leave. I can do a query that will prompt user to enter a date. However, how would I count the total number of clients on that date? thanks a lot for any help!
Hello, I am in the process of trying to get my database so i can access over the web.
Currently over the Lan I have the main database located on the server, and have created a replication for the two clients. This works over the lan where i can open the original and sync etc etc. How can i get this to work over the web so I have the same functionability as the lan method but over the web. I thought of some kind of interface but im not sure on how to do this.
Since I left school I have had to jump into application design on my own because I am finding it difficult to find work without 1 to 3 years of experience typically required by the current job market. This leaves me without any gut feeling for how to charge my customers. Charging by the hour is difficult to do fairly because I am not as efficient as more experienced programmers. Charging by the form, query, report, macro, or module, however, doesn't accurately capture the time variable associated with extensive scripting. Any guidelines offered in regards to charging and possibly ballpark rates would be hugely appreciated!!!
Hi, based on previous advice I had merged my customers and owners into one table and selected whether a client was a customer, owner or both via a lookup table.
This is working fine, however I must assign a rep to each owner, I'm not quite sure how to do this, I need to be able to assign a rep to an owner in the clients table, I must also make sure than a rep can not be assigned to someone who is just a customer obviously.
I have attached the database (http://jonroberts.redirectme.net/database.zip), hopefully that will make things more clear.
I have a table that contains clients. There are a few select times when there will be one client organization but I will need to have two entries--say when one department has a separate contact & record of events than another department.
In most cases these separate departments can be treated as entirely separate clients however in some ways they should be counted as one--such as when counting the number of clients that we serve.
What is the best way that I can accomplish this?
My current idea is that when this situation arrises I have some type of command button that will create a new client record in the table, copy the information from the first record, then I can change it as need be.
I don't know if this is possible, how to do it, and how to set up queries that will recognize the two entries as one record. I don't even know if this is the best way to do it
I need to create a report from a query. I have created the query that pulls the below data from the relevant tables:
ClientName;invoiceAmount;InvoiceDate
Using the wizard I have created a basic report that shows the information in the query, but I need it to list all clients and all months - even if some months show no invoices sent.
Ideally it would show as follows (with an option for the relevant year to display):
______ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Dec Client1 Client2 Client3 Client4
Do I need to create a separate tables for Month/Year and link these to the query? Or is there a simple function I can put into the query to achieve this? It seems a simple task, but after playing for a week I've got no where
I'm creating this database for a claims management company. Yesterday I learnt about making a many to one relationship between the claims and clients tables.
Turns out its more complicated than that. Since I'm dealing with claims, a person may add their partner as the second claimant. (usually the case in mortgages)
So where parties A and B are in a relationship:
person A may claim on their own Person B may claim on their own Person A may be the primary claimant and add person B or conversely person B may be the primary claimant, adding person A.
The end goal is to automatically fill in a financial form (making use of a mail merge). So from what I know I think this means:
that grouping them as one contact is not going to work as I need them to be able to do a solo claim, and also I will not be able to easily change around who is the primary or secondary claimant, which will then carry over onto the mail merge.
So I think this means I need them as two separate contacts. However, I don't know how to create a link between them to easily add their partner to a claim.
Would this also mean I need a many to many relationship between clients and cases.