Search results

Hello, I have survey forms with required fields. When inputting the survey it never used to allow the user to save, create a new one or continue without inputting all the required fields. However I have since been changing my forms adding fields in etc, and now this no longer works on some...

I am placing this code in the field I am validating under the BeforeUpdate field. I am getting a compile error (Expected: =) Any ideas?

Crosstab query problem: Incorrect Values Hello, I need help with data errors I am getting in my crosstab query I am linking a table and a query to create a crosstab query. First Query: Query Of "Internal Survey Data" table Fields are: Kitchen Kitchen Renew Year Table: Table Of...

Sorry to be a pain, but I still dont know how to work that code. My fields are: Kitchen Install Year (which surveyor enters i.e. 2000 and has the afterupdate calc) Kitchen Renew Year (which now auto fills according to the calc)

Thanks for reply. I am new to all this and dont seem to understand. Do I insert a text box with a code builder and insert the above?

Hello, I have 10806 records (Addresses loaded into the database). This includes: UPRN - Unique Property Reference Number Hs No - House Number Address 1 Address 2 Address 3 Postcode These address are linked to another programme via macro import and are updated by a button (Another question...

Thanks for the reply. Not sure I quite understand this. The fields they are filling in are not Date formated, just text. So they can type in i.e. 1999. Iam going to change them to number in the near future. Also do I put this expression as the validation rule?

Thanks. Just a note on the code above, this was meant for Kitchen Renew Year, which cannot be in the past. Do I just change the Install Year to Renew Year? Also I am not sure about the "< DatePart("yyyy", Date())" section as the format is not date. Sorry to keep pestering but is there any...

USER: Firstly opens up the type of survey form Then selects an address (record) by a search button (which is another question) Then they proceed to enter the information. Some tab through or others just click the field they want to fill in. So: Kitchen Type is a combo box where they select an...

Brilliant! Thank you very much it works. I have akward brackets in my field names also. Might be too much work to redo all though. At the moment it caluclates it once you click into the renew year cell, is there any way for it to auto once you have entered the install year?

Thanks for your response. I am new to Access and associated code. I am not entirely sure what you mean. I see the After Update in properties and tried to insert code but with no response. I would try to put a screen print on to show you but it wont let me yet. Try this...

Hello, I am currently developing a database which allows us to collect information about properties. I have the tables, queries, forms etc all setup to carry out what I need to. However to make things easier I was wondering if it is possible to have a field which has a sum as a default value...