Search results

Was the plan in the first place - but I found it much easier for the users to enter two seperate fields rather than one :) P

Many thanks - Solved! and thanks for the tip, but using OnLoad as user will only ever load this form once each time, it will close and re-open to load new data (due to the way the user has to input) Thanks for all your help P

Many thanks for your response - this has helped, however the issue, it turns out, is to do with the connection to the table, and not with the formatting. I can (using your code below) assign the value to an unbound textbox, but when I bind the textbox to the table, it does not like the format. I...

Hello, I have been searching all over for an answer to this, and so far found nothing. The date variable in VBA can store date and time together. So to make my table smaller and easier to modifiy I have decided to store date and time values in the same feild, using textboxes to 'extract' the...

Thanks soo much - was slecting .Recordset rather than .Rowsource For anyone else -> Code now looks (with un-needed trimming) Dim mySql As String mySql = "SELECT DISTINCT [Vessel In Date] FROM [Master Table - Packages] WHERE ([Vessel Name] ='" & Me.Vessel_Name & "')" Me.Vessel_In_Date.RowSource...

Hello, I am getting rather fusrtated - I have built a form including 2 comboboxes. the frist combobox uses an SQL query to select rowsource from my master table fine - however the second combobox recordset will vary depending what is entered in the first combobox. I have written a marco set in...

Thanks for your help - just runs straight off the textbox - diddn't realise it would be that simple P

Well not trying to come accross a daft - but I am much more use to excel. But I understand the on exit event (easy enough) It's just how do I populate the query search permaeter with my textbox value? If it is as below - would this initiate from the on exit event (if I tell it to load the edit...

Hello, Not sure weather to place this under from or query thread. Could somebody please point me in the right direction - I have a form with a textbox, in this texbox the user enters to ID number of a product. I would like when the users hits the enter key, to open the 'edit' form showing...

Hello, Recently I came across a database where - on open, only the main swtchboard form appeared on screen. This was minimized to the center of the screen, and the usual access 'grey' background was minimized onto the taskbar. A user could maximise access to get to the edit tabs, but tabs from...

Many thanks - Link very usefull Will post my code with tweeks once completed

Ok so after some digging I have found so far; Set AcDb = CreateObject("Access.Application") Dim DbName As String DbName = ("My File Name") AcDb.OpenCurrentDatabase DbName From here i am planning to set rs as recordset - make rs the result of the query mentioned above. i will then use...

Hello, Well - before i kick off - I am very much aware that this is both silly and non time effective, but I'll give it a go if i can. I have a rather complicated Excel workbook - in a nutshell the user selects a costomer and enters in a tonne of purchases and variables using several...

Thanks a lot - Turns out you where sort of there. Shall post for other users; As it is using the conditional formatting 'wizard' under expressions the code would be; [Place Field]<>"Place1" AND [Place Field]<>"Place2".....and so on

Apologies - did not specify - I am using a form based directly from a table in my databse And will add signiture - but for reference in this thread i am using Access 2010/Windows 7

Certainly - The Place name is brought into the report from the master table by a textbox called Place Name. There is Just one textbox but the value could be anything that the user has entered. I am trying to apply change in the background colour of a seperate empty texbox if the Place name...

Apologies - rushed my question I have a place name field - i would like the conditional format to apply a colour if the place name is not either of the 3 defined places For instance - [My-Field] Not Or("Place1","Place2","Place3") Thanks

Hi, Have searched all over but cannot find. Is there a way to apply a conditional format if field value is not more than 1 value. For instance I seem to remeber there being an IsNot statement along with an OR statement, however this does not seem to work with conditional formatting Thanks

Thanks once again for your help!

Hello, I have a VBA macro that runs an update query based on user entered values on a form. I keep getting an issue related to date formats - where date values are all in UK format "dd/mm/yyyy" for all tables and forms in the database however, when the date entered in the form is put through...