Search results

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...

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...

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...

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...

Hi There. Im Trying To Filter Records Through A Combo Box Which Is So Far So Good. However What I Would Like To Do Is Select The Records Through The Combo Box And Have It Return And Populate Only Those Records. Has Anyone Got Any Suggestions To This? Ive Attached The Sample Database Im...

HI THERE. IM HAVING A FEW PROBLEMS TRYING SORT THIS PROBLEM OUT. I HAVE A DATABASE IM TRYING TO APPLY A FILTER ON THROUGH AN UNBOUND COMBO BOX. WHEN SELECTING THE DROP DOWN FILTER TO SORT THE RECORDS NOTHING HAPPENS. THE CODE IM USING IS Private Sub Combo??_AfterUpdate () 'Find the...

HI THERE. IVE GOT A QUICK QUESTION ABOUT DATA ACCESS PAGES AND THE DATA THAT IS SHOWN. IVE CREATED A DATABASE THAT HAS AROUND 25,000 RECORDS OF LANDUSE PROPERTIES AND HAVE CREATED A DATA ACCESS PAGE TO VIEW THESE RECORDS. THE PROBLEM IM HAVING IS THAT WHEN I LOAD THE FORM ONLY 1000 RECORDS...

HI THERE IM TRYING TO CREATE A FORM THAT CAN DO SEARCHES ON A COLUMN BY COLUMN SEARCH (EXAMPLE SEARCH A STREET NAME, NUMBER, SUBURB). I UNDERSTAND YOU CAN DO THIS WITH THE COMBO BOX WIZARD. WHAT I HAVE NOTICED IS THAT THE COMBO BOXES I HAVE CREATED OVERWRITE THE EXISTING DATA I HAVE SHOWING...

Hi guys Quick question. im running a planning database which has got 3 tables Objectors, Representations and Agents. Ive put these together using a one-to-many join matching up the index fields from Objectors and Representations. Ive just constructed a form which has a main form being the...