Search results

Thanks Boblarson and missinglinq I am getting some errors with my code. My field names are: Kitchen (15) Kitchen (Renew Year) Kitchen (Install Year) I tried to change the names where you have put them but no luck

Infact. Is there a way of setting up a form where they search for a record, then select the survey form they want and it opens with that record select for them to fill in the details?

I havent got any validations set up at the minute, I am not sure what is required.

Hello, I was wondering if it is possible to setup validation rules on a form to say if you answer one questions you must answer another? For example. I have a combo box for kitchen type so the surveyor selects type, or NONE if there isn't one. If there is one they answer some related...

Hello, please refer to attached pic. I have survey forms which is pre-popluated with certain fields. Ie. The address and tenant detail fields already contain information for 10000+ records. The surveyor searches for a property by the UPRN field and then fills in the rest of the fields for...

Thanks. Yes I had managed to carryout a module for transluscent form. It was more just the background colour that I wanted transparent.

Sorry the second question which I edited was can you make a form background colour transparent. Thanks anyhow

Thanks for all your advice. I am newbie and not sure I fully understand all this. So think I will leave it. Ta all

Thanks that worked a treat! and thanks for your appreciation, still work in progress!

Hello. Refer to pic attached. My form has two borders one to the left and one to the bottom. Can these be removed? Thanks

Hello, I have seen a Module code and then onform load code to make form transparent, however this did not seem to work for me, just made the form look greyed over. Is there anything out there that can be done to make just the form background colour transparent? Thanks

Thanks. Super. Another question - made new thread!

hello, Please find attached. This is a splashscreen which runs for 5 seconds before it opens the main navigation form within the main database. Is there any way to get rid of the "windows box which surrounds it so it just looks like an image floating? Any help much appreciated. EDIT: p.s...

Solved Issue: Had duplicated items in the Promaster cost table.

Ta. I have deleted records anyhow for Security Reasons. But I did what you said and it is now only 1.79mb. Thankyou. Now attached! Help appreciated. Attached is an example of a daatabase for data collection onsite. Once surveys are completed the surveyor syncs (extracts the data to a server...

Thanks for reply. My file is to big to put on here as it contains 10806 records (512mb) (I am using Office 2007) I m not sure I get what you mean above. I didnt use code in the forms other than calcs to work dates out. I created tables with lots of fields and pre-popluated some (i.e...

Thanks. I have managed to sort it now. Ta. just need info on security i.e Users entering passwords for access.

Thanks for advice. I thought the splashscreen was something that replaces the original Access Start up splashscreen. Sorry it is Access 2007

hello i have just seen on a thread that you can create custom splash screens onload. Also with user login. How do you create a custom splash screen to load on start of database? How do you create users so that they can log in with passwords? This wuold be a great addition to my database...

Like the sounds of a custom splash screen onload. How do you do one of them? Also how do you get users and for them to log in with passwords? Infact I wil lcreate a thread