Search results

Hi all When a certain button on a form is click it makes a sub form become visible, I am trying then to make this form exclusive aka, must be complete and stop the user clicking on the main form until this sub form has been complete. I though it was something to do with show dialogue, I have...

:banghead:Hi All Hope someone can help me out. I have a form and a sub form The sub form on it's own is fine, but when I place it into a form I lose the Heading and Border. It's taken me all morning and I cannot figure out why? Pls see attached examples Regards Gareth

Hi My Main Form has a few sub forms within it, but on one particular form when a button is pressed another sub form is 'popped' up but as the sub form is ontop of another the border cannot complete itself. Please see attached. If I remove the border everything is ok, but I really need to...

Hi all I have been given the task to convert an old Lotus Database into Access 2010. My main issue is all the data is on one record, so all customer data and service data. The service data has 6 fields all with dates in, what I am trying to achieve is a query that will bring back the...

Hi All I'm sure i've done this before but simply cannot remember. My main form has a hidden sub form, when a particular button is clicked on the main form the sub form becomes unhidden. I now want the subform to be completed and prevent the user from clicking back into the Mainform, thus...

Hi all I have created some code that creates a temp table in a db then deletes when required. This works fine on my local PC. But I want to be able to specifiy a db on the network for the temp tables but as soon as I try the code just errors. I am new to recordsets so it maybe something...

Hi all Not sure if this is possible but........ If I have a date from value and a date to value is it possible to list the dates inbetween?? So 01/06/2012 - 04/06/2012 would produce a result like 01/06/2012 02/06/2012 03/06/2012 04/06/2012 Thanks Gareth

Hi all A form of mine changes color depending on what a previous form does. My code is simple enough Me.Detail.BackColor = vbRed Which works perfectly But the 'Red' is to errrrrrm 'Red!' if that makes sense. So I am trying to tailor it to a more friendly Red. But if i put in #BA1419 the...

Hi All I have recently had the Package Solution installed so I can create Runtime stuff etc. via the developer program. I uninstalled it as I thought it was interferring with a runtime setup that was trying to find the accessde.dll. Anyway it wasn't. So I have tried to put it back on and...

Hi All Having a bit of a brain block day. A form with a Combo Box on where users can select a Contractor by surname. Once selected the text box carries the Contractors first name, which all works well. But when I try and change the name in the TextBox it does not register in the tables...

Hi All Is there a better way of distinguishing whether a PC is 32Bit or 64Bit?? I am currently just using If statements that if a certain folder exists it must be 64bit else if not it must be 32bit?? Just seems a bit flaky. Gareth

Hi Everyone, I have a Report that consists of 4 Sub Reports (That fit onto one A4 print) and when printing if the sub reports have data to show then they print off without issue. But when the sub report does not have any data then the report just creates a blank space where the sub report...

Hi I have a combo box that has 4 hidden values, I would like one of these hidden values to be added to a field in a table. So I created a textbox with the control source pointing to the field and it's default value set to =[CompanyName].[Column](1) thinking it would place the value in the...

Hi All On a Combo how can I stop users entering there own values?? I've done it before but simply cannot remember how?? Thanks

The following code is working ok. The thing is I have been asked to change the DB slightly, my question is Within the table tblVisits can the DMax check 4 other fields in the table eg CustRef1, CustRef2, 3 and 4?? So I am basically getting the DMax command to check 5 Fields instead of the...

Hi All I am trying to incorporate adding a photo to our Work Permit Database. When a Contractor is added we take a photo and give him a Badge. Exploring the site I have come up with a program called Dorgem which seems to do what I need, but I cannot get Access to save the photo...

Hi All I am trying to get a report to make either one of two text boxes invisible depending on the users input. So if txt15 is blank then visible = FALSE this should then reveal txt18 which should then have data in. I have looked through the forum and found something similar to the...

Hi People I am trying to nail some DMax code, and could do with some help I have an unbound text box called DateOfPrev, I am trying to get the code to lookup the last date that a particular client visited our site =Dmax("DateOfVisit","tblVisits","CustRef = txtCustRef") The above code...

I know this topic has been extensivley written about but I could do with some guidance. I have a form with about 10 textboxes on. The first textbox gets it's date from the Release Date, less 30 days. The other textboxes get there dates from similar offsets off other textboxes cascading down...

Hi everyone. A subform has a TextBox called 'PlannedStartDate' bound to table tblCSP The main form (frm_ContractHeader) has a DateRequired Field. On the subform, if I puts it's default value as =DateAdd("d",-33,[Forms]![frm_Contractheader]![DateRequired]) then the textbox is blank. If I...