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.

View Replies


ADVERTISEMENT

Forms :: Record Availability Of Volunteers For Different Events In Database

Jul 14, 2013

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.

View 1 Replies View Related

General :: Send Email To Individual Clients Via Access Database 2003

Sep 17, 2014

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.

View 4 Replies View Related

Null Handling In Access Database

Jan 8, 2014

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).

View 14 Replies View Related

Forms :: Limit Number Of Clients In Date Range

Aug 30, 2013

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..

View 1 Replies View Related

General :: Handling Error Database Engine Cannot Find Record

Jul 8, 2013

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?

View 1 Replies View Related

Tables :: Claim Tracking Database - Structure For Dates Of Events Related To Claims

Feb 28, 2013

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.

I currently have the following tables set up:

tblClaim
ClaimID
ClaimNumber

tblEvents
EventID
EventName

tblClaimEvents
ClaimEventID
fkClaimID
fkEventID
EventDate

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.

View 4 Replies View Related

Events In Forms

Mar 16, 2007

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()

Verification enters |PATIENT INFO| |VERIFIED y/n| Verification 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?

View 5 Replies View Related

Handling Filter In A Ms Acces(2000) Forms

Oct 19, 2006

hi,

i am currently dealing with a form which does not show data after it has been opened.

it shows the data after removing the filters from the form when it is opened.

in fact the filters are set to false

Me.FilterOn = False.

so kindly help me out from this problem

thanking you

View 3 Replies View Related

Forms :: Handling Abbreviation - Autocorrect Options?

May 20, 2014

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?

View 1 Replies View Related

Handling Filters In A Form

Oct 19, 2006

hi

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

thanking you

View 6 Replies View Related

Forms :: Trapped By Text Box Before Update Events?

Aug 3, 2015

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.

View 1 Replies View Related

Forms :: After Update / Change Events Not Working?

Dec 16, 2013

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.

View 7 Replies View Related

Forms :: Handling Large Amount Of Data In Memo Field

Jun 9, 2013

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.

View 8 Replies View Related

Modules & VBA :: Ignore Certain Events In A Form?

Apr 9, 2014

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?

View 7 Replies View Related

Modules & VBA :: Mouse Events On A Form

May 27, 2015

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.

View 10 Replies View Related

Forms :: Display Number Of Events Taking Place Today

Dec 17, 2013

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.

View 1 Replies View Related

Modules & VBA :: Copy A Record Without Triggering Form Events

Dec 30, 2014

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?

View 2 Replies View Related

Want To See Only Those Clients Who Has Email Id

Dec 25, 2006

I have a table -'client' with 5 fields,
id
name
address
email
mobile no

I want to see only those clients who has email id.

I know its simple but not so simple to a layman like me :)

Please help

View 3 Replies View Related

How To Count Clients For A Certain Date??

Jul 29, 2005

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!

View 3 Replies View Related

One Server, 2 Clients Help Needed To Access Over Web

May 2, 2007

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.

Thanks in advance
Craig Clarke

View 3 Replies View Related

Guidelines Needed Regarding Charging Clients

Nov 18, 2007

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!!!

View 7 Replies View Related

Clients Table Help Needed, Filtering

Jan 7, 2006

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.

Thanks in advance.

View 2 Replies View Related

General :: Sub-Clients For Records In Table

Jul 3, 2013

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

View 2 Replies View Related

Reports :: List All Clients And All Months

Apr 11, 2014

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

View 9 Replies View Related

General :: Link Two Separate Clients?

Apr 9, 2013

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.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved