Search results

Hello. I was wondering if the following was possible. I have 10000+ records with a unique 'propref' number in the database. I also have tens of thousands of photographs on a network drive all with the propref encorporated into the title. is there a way to get some sort of link so that...

Yes the form opens up with full recordset. But I just want to export 'Current Selected Record' within the form to a PDF via a button.

The data is a number but design is text. however the propref may contain a letter at the end in some cases but not yet.

Hello. I am having trouble exporting single records from a form to pdf. I have the following code so far. but it gives: Run time error 3464 Data type mismatch in criteria expression. Debug highlights: Me.RecordSource = "Select * From Propertyextract Where [propref] = " & _...

Thanks. I have resolved this issue now. I created a query of Propref and then concatenated hsno and address 1 with space. and then used my search code like previous to link the proprefs. So user no enters for example 32 smith street and if this address has a propref it finds it and brings it...

I cant get any sort of textbox and combo to work

Sorry no the: hsno is just the number of the house. Address1 is the street name. So combined would find the property. i.e hsno 45 Street name: Smith Street. However there could be many 45 hsno against street names.

We have 80000+ properties to complete. 10000 is just a start and we have not populated all data yet, but we have got approx 600 full complete surveys against 10000 populated address which has taken 8 months. I do not understand how to create that joint combo box for when they start typing?

There is 10000 records.

Hello. I have the following code which I use one my forms to search and bring up a record. It works great. However it requires the user to know the actually unique property reference number to search. Private Sub cmdSearchPropref_Click() Dim Rs As DAO.Recordset If Not...

RESOLVED: Update to: Year(Date()) Criteria: <Year(Date())

I have tried this: Date("yyyy") but this does not allow saying the expression has the wrong number of arguments.

Sorry not sure what you mean. The renew date fields are collected by a surveyor on another database then data is uploaded into this one. The purpose is to see what year an element on a building requires replacement. Such as windows, doors, kitchens etc. The renew year cannot be less than the...

Hello. I wanted to create an update query to enforce all Renew Dates within my fields are atleast the current year. I have created the following - see picture. But all it does it changes everything to "Date" text within the fields. Can I create an update query to do such a thing. I.e. The...

Hello. Not sure if I can explain this well, but here we go. I think the picture attached might help to explain. I have a database which looks at elements within a property i.e kitchen and when the kitchen is to be replaced. The query looks at the kitchen type and the renew year then the...

It is not a subform in control. I have got an embedded Object Source. And depending on what command is pressed the subform appears i nthe control source. I have not got all the subforms preloaded and hidden. I want to be able to open the form within this embedded blank object source on the main...

Hello. I have a command button which is password protected by a custom form with a password txtbox. If the password is correct I want it to then open a form. However the issue is - I want to open up thid form as a subform on the controlsourceobject in my main form. Is this possible? My...

Resolved! VBA code to link tables on application load

Resolved! Fe and Be linked tables Hello. I have finally finished one end of my database. I have the FE and BE all sorted. I have packaged my database up (with access runtime). However it installs fine but when I try to open it crashes and does not go any further than the first splashcreen...

No there just field names in a table. I think?