Search results

hi there im having trouble with the below syntax when trying to dun the sql Count(BaseData.Date of call) Im not sure how this fits in??

hi there. thanks for your help. ive tried adjusting the sql statement but it doesnt seem to work. i was wondering whether it is possible to do something like this in expression builder? thanks

Hi there. Im trying to work out how I can count the dates in my database per month. What ive done is created an unbound box with an sql statement SELECT Count([tbl Main].[Date of Call]) AS [CountOfDate of Call] FROM [tbl Main] HAVING (((Count([tbl Main].[Date of Call])) Between #4/1/2006# And...

Hi there I have a fairly simple table that has some address details apart of it. This part of the database is likely to be used fair bit. What I would like is function that allows to auto update the address details from the drop down list of a company name. Im hoping this will save time on...

Hi there I have a fairly simple table that has some address details apart of it. This part of the database is likely to be used fair bit. What I would like is function that allows to auto update the address details from the drop down list of a company name. Im hoping this will save time on...

Hi there I have a fairly simple table that has some address details apart of it. This part of the database is likely to be used fair bit. What I would like is function that allows to auto update the address details from the drop down list of a company name. Im hoping this will save time on...

Hi there I have a fairly simple table that has some address details apart of it. This part of the database is likely to be used fair bit. What I would like is function that allows to auto update the address details from the drop down list of a company name. Im hoping this will save time on...

great suggestion! where are the access bmp files stored? i cant seem to find them. cheers

hi there. thanks for replying. im using the same code however the problem im having is that when i include a gif button to act in the same way as the normal default raised buttons in access the control does not work. do you know a way around this? cheers

Hi there Im having a few problems trying to get my login form to function properly. I have created a username and login form. - created 2 unbound text boxes with user and password - created a button that performs the function of calling the username and password based on whether the user...

Hi there Im having a few problems trying to get my login form to function properly. I have created a username and login form. - created 2 unbound text boxes with user and password - created a button that performs the function of calling the username and password based on whether the user...

Hi there Ive created a username and password login form with both text boxes unbound and login button with the following code. Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box If IsNull(Me.cboEmployee) Or Me.cboEmployee = "" Then...

Hi there. Does anyone know how to use an update query to copy some records from one table into another? I have table1 which has all the contact details and what I would like to do is work out a process for importing records from an excel spreadsheet. What I have so far is as follows: 1. In...

Hi there I have a database that im working that has a main tbl and secondary tbl linked as one-to-many. On my forms I have main frm and the secondary frm linked as child fields. Through this i have queries for both main and secondary tables. In my secondary form i have several unbound boxes...

Hi there This may seem to be a very general question for some but im wanting to find out what the best possible way of filtering records? I have a database that structurally is split up into 2 tables. The one table refers to primary address information and the other table with the more...

thank you very much. seems to work like a treat! cheers

HI THERE I HAVE A DATABASE WHERE THERE ARE CERTAIN FIELDS THAT NEED TO BE SUMMED UP. I HAVE BUILT A UNBOUND TEXT BOXES WITH THE EXPRESSION BUILDER TO SUM THE FIELDS IM WANTING. THIS IS FINE HOWEVER WHEN THE RESULTS ARE SUMMED ALL MY RECORDS ARE BEING SUMMED TOGETHER. WHAT I WOULD LIKE TO DO...

Thank you very much! Works like wornders Cheers :)

How does this sit in conext of code?

Hi There Im Trying To Find A Solution To My Problem About Searching Records Through A Recordset Filter. I Have Performed The Follwing Code To Filter My Records From The Combo Box However In My Database I Have Several Yes/no Fields That I Would Like To Filter Out As Apart Of A Recordset. Code...