Search results

You my friend are an absolute legend!!! Thank you :)

Thanks for your help on this. Here is the debug SELECT TestTable.Hours FROM TestTable WHERE (((TestTable.sUser) = 'test.user' AND ((TestTable.[Task Date]) >= #02/09/2013# And(TestTable.[Task Date]) <= #06/09/2013#; Data types are sUser = Text Task Date = Date/Time - short date :confused:

Any idea what would cause a syntax error in query? The error 3075 shows the expression and it shows that the form values are correct for example the task dates resolve to the task dates in question from the form along with sUser Thanks :)

Hi Guys, Ive got an SQL query as below, what Im trying to do is get the total value of that SQL query and drop it into a form text box. The placing of the result on the form textbox isn't a problem but getting a sum total of the query result is proving to be a little tricky tricky tricky...

Hi, Ive never got on with relationships (within Access - not the one with the wife:)) Is it bad practice to link tables using joins rather than making relationships between those tables? I appreciate the basics of relationships, but providing that you can access the relevant infor using...

Exactly what I was after :)

Afternoon, Im not sure this is the correct way to go about it but - here goes... So I have a lookup button which queries multiple tables to get Address details, and populates the address details (as a company could have more than 1 address) in a list box. I then select one of the address's...

Fixed - it was in the format of the table :)

Got it working, just needed to think about it logically. A slight issue now is the VBA code is removing the preceeding zero from the form. So a number is 0298785487 its captured as 298785487 - any ideas why this is? Thanks

Hi guys, Ive got monday mind block (if there is such a thing)?? Trying to deal with if then else statements. Whats the best way of going about working with if a field is blank then, within a VBA statement. Ive written the obvious If Me.telnumb_txtbx = "" Or...

Thanks Ive never really understood where the brackets should go and looking at your example above youve commented the start of the select agreement and parethsis (brackets) the end, shouldnt it end with "'" ?

Hi All, Ive got a strange issue with my DB. The below code looks up a company ID from the CompanyInfo_tbl and then looks up all records which have that ID and takes the first and last name and populated that within a combo box. Private Sub Contact_Combo_GotFocus() Dim strCompanyID As Integer...

You wouldnt know how to clear down a list box upon exiting the form? If I use me.listbox = "" Nothing happens, no error but the listbox is still populated. Fixed - there was content within the property as well as the VBA Code.

And bingo was his name-o... Thanks works fine :)

Hi guys, Im currently pulling my hair out trying to overcome this one. I would like to populate a listbox based on an sql query which gets its record from a combo box... Ok so the way Ive done it so far, my combo box is populated from a column in the table as per Private Sub form_load()...

Hi all, Im currently creating a switchboard interface which will then access the different DB's accordingly. My current code(button) opens another instance of Access but the new instance isnt full screen. Also is there a way to cloise the switchboard DB\form upon selecting to open one of the...

Worked like a charm, thank you :)

I too had a simular issue, I had some code to check if users had entered data and not saved properly but they still seemed to close the database without checking what they had done first. So I opted for this 'Here Private Sub Form_Unload(Cancel As Integer) 'Cancel = Not mblnClose End Sub...

Hi all, Im trying to output to a textbox the result of a dsum, also Im wondering if this is possible to have some sort of dynamic control so a user changes the selection in the combo box and the date ranges in the "From" and "To" dates and the result is updated based on this. My current code...

Hi all, Im looking to either link or import tables from a different DB. The DB has security on it but Im not sure how to pull the information across. If I use Excel and get external data using a Microsoft Query Im prompted for the credentials and then I can query the tables. Is this something...