Search results

Hi again. I managed to fix the truncation error and now all information is showing in both the report and the source query. The only problem I am having now is a parameter box that keeps popping up when I run the report that keeps referencing the memo control I was having the issue with in the...

The query is grouped because drawings can have several revisions throughout the course of a project. The detailed drawing register lists each revision and what the changes were where as the summary only shows the most current changes. When I was building the database, the only way to show the...

Thanks...that I understand how to do! I really wasn't understanding how to correct the problem from the notes provided yesterday. Thank you so much for your help

Forgot to mention...I'm using Access 2010

Good morning...sorry for the delay in responding (5 hour time difference). I have edited the database as much as possible attach the compressed file. The issue is the Drawing Register. When the main menu comes up, go to drawing registers and select Contract Scotiabank. Then select Summary...

I've tried the different workarounds but none are working or are applicable. I was wondering if the database itself is getting too big or is becoming corrupt as I have noticed a few other quirks recently. I have been using this for 3 or 4 years now and this is the first time I have encountered...

The query is somewhat complex (for me at least) and is based on 2 or 3 other queries. It is a summary showing the last entries of a construction drawing register. The detailed drawing register which shows all drawing revisions to date is displaying correctly.

I've attached a screeshot of what the report is showing and circled the field that the text is incomplete. The full text should be as follows "ABM Room - revert to original position for table and overhead shelving. Manager (116) - indicated existing gypsum enclosure for AC line; relocated...

Hi..yes it is a memo field. The SQL is as follows (hope I'm doing this correctly) SELECT [Copy Of QRYSmryDwgRegRpt].ContractNo, [Copy Of QRYSmryDwgRegRpt].ContractName, [Copy Of QRYSmryDwgRegRpt].IssuedBy, [Copy Of QRYSmryDwgRegRpt].DrawingNo, [Copy Of QRYSmryDwgRegRpt].DwgNo, [Copy Of...

I'm not seeing any overlaps. It's just cutting off mid sentence when there is room to complete the sentence. I also checked the section and that too has the Can Grow set to yes.

Good afternoon, I have a control on a report that is not showing all the data. In the Properties for the control, I have Can Grow set to yes. I tried changing the Text Format from plain text to rich text but that is not a valid option for this control. Any suggestions on how to correct this?

Thank you both. Changing the date format to yyyymmdd worked - Format([WkEnding],"yyyy/mm/dd")

How can I sort a crosstab query by the date field? The table/query used in the crosstab has a date field which enters the information as dd/mm/yyyy format. This date field is a column heading in my crosstab query and it is sorting the columns by the day field and not in date order e.g. the...

Thank you all so much for your help on this problem...I really do appreciate it and know I made a critical error in setting this database up. The problem is that this database was needed in a hurry and is still being built as it is in use. In one week it already has close to 400 records...

I admit that I made a non-rookie rookie error :( The problem is trying to correct related records - the changes are not being accepted as they are related to the EmpID primary key. I can't delete and re-enter as it will change the numbering in the autonumber field of these tables which will...

I was wondering if the value of a primary key can be changed. The information being keyed in the table is from another (non Access) database. The primary key generated uses the first 4 letters of a persons surname and then adds an autonumber to the end. To avoid confusion, I have been using...

I've attached the relationships report for your reference

To clarify the information in the forms is pulled from tblSubContractors and tblSubContractorJobDtls tblSubContractors is just basic info - AutoID, Name, Address, Contact numbers. tblSubContractorJobDtls is joined to tblSubContractors by AutoID. The information in this form is the JobNumber...

Hi again, I have two combo boxes - cboSubName and cboSite When I select the SubName from cboSubName, the combo box cboSite refreshes to list the jobs on which that particular sub is working. I want to be able to add a new job to that sub-contractor by using the List Items Edit Form and having...

I have a main form named frmInvoices and subform named frmInvoicesDtls In the main form, when I select the SubName from the cboSubName, the combo box cboSite refreshes to show only the job sites that particular sub-contractor is working on. For each job site, a new order number is generated...