Recent content by maisam

Problem changing a BackColour of a textBox in my report! Hi guys, I have a slight problem formatting one of the text boxes in my report. I want the colour of the text box (BackColor) to turn grey when the value of another field (Tag_Tgt_Diff) is > 0. However when doing the code the BackColour...

Guys I need your help/Advice... In my Access Database I have a query (lets say qry1) and in this query i have 2 fields for start and end date, which is provided by 2 Get functions. also i have qry2 based on qry1 then qry3 based on qry2 and finally qry4(using sql in code) based on qry3, and non...

Guys I need your help/Advice... In my Access Database I have a query (lets say qry1) and in this query i have 2 fields for start and end date, which is provided by 2 Get functions. also i have qry2 based on qry1 then qry3 based on qry2 and finally qry4(using sql in code) based on qry3, and non...

hi guys, i am creating a report in an access databse. in this report i need to show data from a spreadsheet that is automatically updating every day. how can i transfer this data into my databse in order to show it in the report. is there any way that i can populate a table with the data from...

Hi guys, I have a text box, which requires a 8-digit number entry. I have wrote the code to check that the length is 8 and if it isn't a label will turn visible next to the field telling the user entry must be 8 digits. This works for when i enter a number less than 8-digits but when i input a...

hi guys, would someone please tell me if it is possible to locate the form in a specific location on screen, e.g. starting from top left corner or basically have the form open in centre of screen?! I have created my database in Access and now trying to make the forms appear on screen as neet...

Kempes, Do you mean on Close event of the form that i want to keep its original size, or the close event of the previous form which it is set to maximize on the open event? the thing is i don't want the maximized form to close once the second form is opened! the second form is basically a pop...

Yes. The Auto Resize is set to 'NO' in properties but it still maximizes once it is opened! Tricky!

Hi guys In my database I have a main form and depending on the options chosen on this form other forms will pop up on the screen. I want the main form to cover the whole page therefore in the On Open event I have used the Docmd.Maximize function. The problem is that after this point all the...

I sent a post earlier today about making a label visible in a subform! I am still working on it but still no progress! I have a different scenario (its the same thing but trying to explain the method i'm working on): I have one main form (frmMain) that contains 3 subforms, say subfrm1, subfrm2...

Hi guys, I have a form (frmMain) which contains 3 subforms and they are being set to visible at different stages of application run (depending on the options selected). In subfrm_Main_options i have 3 buttons, clicking on 'Job Review' will make the subfrm_Search visible. In the subfrm_Search...

Thanks for your help guys! the db1.mdb didnt open for some reason! but the first suggestion works fine, exactly what i was looking for! cheers, appreciate the time you guys have put into this! maisam

I am trying to create a report (rptHBSummary) that has all the fields in one table (tblJob) and an extra field that calculates the maximum value of a particular field (Percent) in a different table (tblJobStatus). More detail: in this database jobs are inputted into the system (into tblJob) and...

i have a problem adding the data from the fiels on the form into a table. I know you can just click on the navigation arrows and it will save the record but i want to use a submit button as this is more user-friendly and suitable for the work i'm doing. I have attached the database... the form...

i am trying to use a subform to add data to table. if you look at the access file i have attached you see that i have a form 'frmSearchReasult_Status2' which has a subform called 'subfrmJobStatus'. The main form contains a Job (pulled out using a query) and the subform contains Status of that...