I have two separate fields in my Report. I want the users to select a project from on field and then the other field will automatically be entered into the second field. How do I go about doing this? Please HELP!!
I am ghosting one of my computers and it took about an hour for the ghost software to do one partition. It started slowing down when it was prossesing "Unnamed MFT Table entry". If you have any idea what this could be, could you let me know!!
Thanks for your help,
Steph
Tom
That sounds good but I have to go through a few people at work first to see if I am allowed to send the Database over the internet. It might take a few days is that alright?
Just let me know.
Steph
Tom,
I went into the form and at the bottom of the form displays the "qryConfigItems(find)". I then went and viewed the properties. when I closed out of the properties and tryed to go from the design view to the form view an error message appeared 'Query must have at least one destination...
Tom,
The databases contain sesitive infomation so I won't be able to send you the database, Because, of course, that would be the easist thing to do. the other problem is that I'm located in Maryland.
I looked at the "qryConfigItems(find)" since both of us couldn't find out the relationship...
Tom,
Thank you for all of your help so far!
I made all of your recommended changes,
I located the code for PrtECPData, there is two seprate queries for Preview and Print, but they seem to be the same.
Then I tryed to run the debug/Compile Inventory Control 1. It runs now without any errors...
Tom,
Thank you for all your help so far. It's exsactly like finding a needle in a haystack, you took the words right out of my mouth!!
The Record Source for the: qryConfigItems(find)
SELECT qryConfigItems.[ConfigItem #] AS [CI#], qryConfigItems.ProductName, qryConfigItems.Version...
Tom,
Record Source for the report: qryECPDataFind
SELECT tblECPData.*,[Document#]&"-"&[NewRevLvl]AS ECPNumber,
tlbProject.ProjectManager
FROM tblProject INNER JOIN tblECPData ON tblProject.ProjectName=tblECPData.ProjectName
WHERE ((([Document#]&"-"&...
May-be I can help by giving you alittle background!
I just started working with my company and I have never delt with Access before but I was through into it and told to fix the problems. I took one class and thats it!!
so Yes I have a Query named "qryConfigItems(find)" - not sure if anyone...
well each time that I open the form wether or not I make any corrections, the warning "Do you want to save changes to the design of query 'qryConfigItems(find)'?" appears.
I keep receiving this error message every time I close out of a certain form "Do you want to save changes to the design of query 'qryConfigItems(find)'. Please Help!
Thank you very much!! I went through and found the one that was causing the duplicating, removed it and reentered the data. So far so good!! Thank you again!
Thanks that helped! For some reason the qryECPDataFilter(Project)is duplicating in this job. can't find the duplication in the table, but I will still keep looking! If you know of anything else just let me know! Thank you.
SQL view:
SELECT {qryECPDataFilter(Project)}.*,tblProject.Introduction,tblProjectManager
FROM tblProject INNER JOIN {qryECPDataFilter(Project)} ON tblProject.ProjectName = {qryECPDataFilter(Project)}.ProjectName;
May-be this can help!!
Thank you!
I am not quite sure that I understand? I think that is's my falt!(sorry just started working with access and I was thrown into the database to fix the problems for work). I have a form that reads different data depending on the user chose and what Number they chose. The form prints out fine...
When I am printing a set of forms from a selected job some how I am printing double. This only happens on selected jobs from the database. Some print out good and others print out doubles? Please Help!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.