I have a database that keeps tracks of the orders that clients make and when I do a search from my search form, if the client is in the database but haven't made any orders. A solid blank screen opens up. Is there a way to stop this to show a message box if there are not orders?
View RepliesWell, my newbie status in db development has reared its head. I knew from the beginning I didn't want to have cascade delete when deleting a clinic (parent) from the db. Problem is some queries in other areas need some clinic info and if the clinic is deleted, it won't be available. Right now I'm thinking that an easy way out is only allowing a delete if it has no attached records. If the clinic is no longer used, they can just write in the memo field that this clinic is no longer used. It's not a large db and there won't be hundreds of clinics so it may not be too bad. Any other suggestions?
scratch
I have a DB with a form based on a query where we keyin a parcel identification number (PIN). If there is a corresponding PIN the form opens. If there is no PIN available, a blank form appears. Is there a way that if no corresponding PIN is found, a different form or message box would open stating "No parcel available"?
Thanks,
SKK
I am trying to build a form with feilds from multiple tables in access 2002. When I use both the design view or the wizard to build the form, the form displays in design view, but is blank and unusable in all other views.
View 3 Replies View RelatedI am currently working on a database and I am stuck. I have a form which accepts the company's information and the company's reference number. Now if I want to keep different jobs from this company in the database I know I have to reference them to the Reference number. Does this mean I have to create a seperate form to take the job information or can I just add to the main form. I noticed when I tried to add the job information in a seperate form, I wasn't allowed to use the reference number due to it being a primary key. Does this mean somethin about me having to let my table have children?
Sorry for sounding like a mad man but can someone help me. I have looked at the northwind example and it ain't helping me here. I also noticed if I try to create a form to allow data entry, it is never blank, it always starts off at my first record of the table
I made a delete query. In the query the from table is linked to it's child table. I dragged down a field from the child table and specify Is Null as crieria
If I view the query it shows all the entries with no children, which are exactly what I want to delete. However when I run the query it gives this error:
Could not delete from specified table.
Could any one please help. thanks in advance.
ad
I have a parent record and child records. After creating the parent, there must be at least one child record.
On closing the form I could, in principle, delete the parent and child (or children), if the user changed his mind.
Or, I could presumably wrap this entire enterprise in a transaction, something along the lines referred to here: [URL] ....
In a form used to record a sale for a company we have a dropdown box with the contact names for that company and when one is selected it populates other boxes like phone number etc however the combobox brings up all possible contacts but when some of them are selected all the boxes return blank, including the combobox, whereas most of the contacts work fine.
The SQL used for the combobox is as follows..
Code:
SELECT tbl_Contacts.ContactTelephone, tbl_Contacts.ContactMobile, tbl_Contacts.ContactEmail, tbl_Contacts.ID_Contact, tbl_Contacts.ID_Company, tbl_Contacts.Salutation & " " & tbl_Contacts.ContactForename & " " & tbl_Contacts.ContactSurname AS MainContact
FROM tbl_Contacts
WHERE (((tbl_Contacts.ID_Company)=[tbl_CompanyBookings].[ID_Company]))
ORDER BY tbl_Contacts.ContactForename;
Why some contacts work and some don't ??
So what I've basically got here is a form with 4 combo boxes and a button that when clicked will filter the results of a table (which is a subform/subreport) based on the values inside the combo boxes. So the problem I have is that when I open up the form it displays a fully filled table but I just want to display the row names and a blank table until the filter button is pressed.
View 2 Replies View RelatedI have a form set to the table Client Information with a subform set to the table Event Information. Client Information has a one to many relationship to Event Information.
There is a button that deletes the current record in Client Information--also deleting the related records in Event Information--then closes the form. The code works fine but a blank record in Event Information is apparently being created before the form closes.
Here's the VBA that I'm using:
Private Sub CmdDelReturn_Click()
Dim CmdDelReturnMsg As String
CmdDelReturnMsg = MsgBox("Delete event & client then return to front?", vbYesNo + vbDefaultButton1, "Delete and Return?")
[Code] ....
It's not a big deal because the button won't be used often and I can manually go into the table to delete the blank record. But if there's a simple solution to prevent this that would be nice.
I've created a form for updating / inputting data to my table. Currently it is defaulting to show the existing data from record 1 of my table. But as the most frequent requirement of the form will be to add a new record to the table, I would like it to default to show a new blank record. Is there a way of doing this? Perhaps some code that I could incorporate against the "on activate" for the form.
Thanks.
I have a problem with my database I have a combo box that will search for my record. Actually its working I input the specific number it goes to the specific record. But I want, if there no existing record in my database it will display a Messagebox that "No record Found" I try to put a code in a macro builder in a after update property field but nothing happened.
Expression code that it will display the msgbox if there's no record found.
the given code from macro builder is attached. I try to have an if else statement but I dont know how to not equal that giver conditional expression.
I'm trying to make a form that shows what the last record was next to the empty space where you enter a new record.
This is so the user knows that what they are entering is roughly in line with what has come before.
So for example if I was recording temperature every May, I would like a form that has a field called temperature and next to that field I would like to see last year's temperature.
Records:
Date | Temp
2014 | 20.5
2013 | 18.5
2012 | 19.0
2011 | 22.7
2010 | 15.2
So when I enter the record for 2015 I have a box that says: Temp and next to that box is "Last year was 20.5" or something like that.
I have a form with a drop down of employee names and a tabbed subform.
I have the form and subform set up to open on a new record and, when the employee name is selected to fill the subform with that employee's data.
It is a split db with the be on the network server and everyone has their own copy of the fe. When I open the front end the combo box is blank but the first page on the tabbed subform shows data. If I close it and reopen it, sometimes its blank and other times it still shows data.
What else do I need to do to ensure that it is a blank record?
Also, I am using the MouseHook.dll and included it in my .exe (zip) file to all of my users, instructing it to download to the same location as the .mdb file (C:/Training Database). Will this work or does the MouseHook.dll need to be somewhere else?
Thanks,
Toni
i have a subform as a continuous form, and at the bottom, there is the normal blank record (created automatically), to enter a new record. Is it possible to attach a piece of code to a field but which will be available only to the field of this blank record, rather than being available for the particular field of all the records in this continuous form ?
Basically i want that if the focus is on this blank record, and i will hit the tab key i want to move the focus to a control, on the main form, that's why i want it specifically, when only this blank record at the end has the focus.
Thank you for any suggestions.
I have a main form with many subforms. The sub forms are all continuous but one and I want the editors to be able to put in more then one record if needed.
My problem is I have my tabs set up so that when the box is empty it will tab to the next subform. When I do this, a extra blank record is automatically saved in the subform above. How do I get rid of the blank record?
Thank you in advance for any advice shared.
I've got a text box, populated by a query.
(it looks like a list because it's tabular view)
you can always see the empty record... any way you can stop it showing?
or failing that, I have a dblclick event on all the textboxes. But It doesn't work with the blank record..
this is quite frustrating.. any help please?
Please find attached table
When saving a record first one is blank row how to solve. For the first time only it happened why? How to solve.
Hello eveyone . . .
i am attempting to create a VERY complicated query . . . it's sort of confusing:
I recieve data from an outside source and it is up to us to format it for our own analysis . . .
i have fields:
MethodCode..... AccNo .....PatientName.....MR..... TestCode ..... etc, etc
The fields we want to focus on is "AccNo" and "TestCode"
Now i want to filter based on this condition:
If "AccNo" AND "TestCode" BOTH have duplicate data in a record. Show that record only once. Remember. . . "AccNo and TestCode, both these fields have to have duplicate data in a record.
Example:
MethodCode..... AccNo .....PatientName.....MR..... TestCode ..... etc, etc
CAPT.....M566679.....John Blue.....123456.....CBCA
CAPT.....M566679.....John Blue.....123456.....CBCA
the example above should only display once because of the repeated AccNo and TestCode
Example:
MethodCode..... AccNo .....PatientName.....MR..... TestCode ..... etc, etc
CAPT.....M566679.....John Blue.....123456..... CBCA
CAPT.....M566679.....John Blue.....123456..... LIPID
the example above is just fine because the TestCode is not matching
How do i create a query to accomplish this? someone please help, i've had troube with this for the passed couple weeks . .. .
I have a form that is used to both Enter & Edit records. There is a "search" button to aid in finding records.
I have been asked to have the form open to a blank record instead of the first record in the table.
Is there a way to do this without setting the "DataEntry" property to true, as this basiclly disables the "search" button.
Thanks
I'm trying to make a form so that it opens up to a blank/new record. Any tips? Can't seem to figure it out.
Thanks, Jonathan
Have a strange problem. I've created a form with multiple subforms and if there is a record for the subform to display everything looks fine. However, if there is no record for the subform it does not show anything on the screen or if printed.
I would like for the fields on the subforms to show no matter what but I can't figure out why it doing this. I've checked the display parameters and everything is set right.
How do I make the forms show no matter if there is data to display?
Any help is greatly appreciated -
Thanks
HELP
When the user double clicks on the icon, the form automatically appears on the screen. That's good. But record number 1 is there. I want a blank record there so they can enter their data. This can't be difficult, but I can't figure it out.
How can I create a criteria to delete the entire record in a query if the LnPreApprConvDt and LnPreApprFg are both blank?
View 1 Replies View RelatedHello all!
I have a database that needs to post records that are joined from three different sources into a table. The query is done, and I get about 1,489 records out in 4 different states.
What I need to do is make a table with these records. Furthermore, it must be separated by state, whereas if there are less than 1000 records for each state, it must insert blank lines until it reaches then next thousandth (sp?) row (i.e. 1001, 2001, etc.), and then start posting the next state.
For example, AZ has 420 records. There has to be 580 blank lines before the query can start posting the next state, CA. At row 1001, CA starts posting, but there are only 200 records for CA so there must be another 800 blank lines before moving on to CO at row 2001, etc. etc.
Anyone have any ideas on this? Thanks!
I have a simple dbase that lists individual staff members' qualifications, skills and hobbies.
One person may have 20 qualifications and another may have 1 or none.
I have a separate field for each qualification.
Is it possible to write a query that only returns fields that are not null in each record so that the subsequent report is not full of blanks? I know I can use Can grow - Can shrink on the report but I'd rather eliminate blanks via a query if I can.