Search results for query: *

I have been using the query below to try to provide an accurate stock level from two tables tbl_Delivery and tbl_Sale. I can produce results from 2 queries (qry_DelivertTotals and qry_SalesTotals) that summarise how many of each product have been delivered and how many have been sold. Whilst I...

There is probably a very simple answer to this problem ,but I have not been able to find anything in the HELP files I have for Excel which moves me towards a resolution. Basically I am using a LOOKUP function to connect the full address and event details (stored in Table 2) to a date and...

Apart from the slightly different order of field specifications, can some kind individual tell me what the difference is between these two SQL statements? STATEMENT 1 SELECT GESTUCENTRES.SetId, GESTUCENTRES.StudentId, GESTUCENTRES.CandId, GESTUCENTRES.CentreId, GESTUCENTRES.CandNumber...

I have two combo boxes on a form. The first box I want to populate with names of the tables in the database. The second combo box I want to populate with names of fields within the selected table. I know how to generate the list of tables, and the fields within them, but how do I get these...

I've been away from Access for a few months and feeling very rusty. There is probably a simple answer to this question, though I can't find anything in Access Help or in these forums. How do I edit an existing option group on a form? I have an option group with three tickboxes and now want to...

I am amending data in an Excel spreadsheet from within Access using VBA and then saving the updated file using xlBook1.SaveAs Filename:=Dir & "\tblChildData.xls", FileFormat:=xlNormal, CreateBackup:=False With warnings already turned off, is there a way of amending the syntax to...

Is it possible to change the content of a cell in an Excel spreadsheet from code within Access? I have a number of spreadsheet files that need to be imported but the heading of one column is incorrect and needs changing to "SENStatus" before I use the Transferspreadsheet command to...

I have a combobox that provides a drop down list of users based on the following SQL: SELECT [child surname] & ", " & [child forename] AS [Child Name], tblChildData.childID, tblChildData.[child surname], tblChildData.[child forename], tblChildData.Active FROM tblChildData WHERE...

I have a complex database (not mine, I hasten to add!) with literally dozens of tables. There is a problem with the use of data in one field (LecturerID), which appears in a number of the tables. However, without going through the tables individually on a manual basis, is there a quick way of...

I have a subform linked to data in a separate table to the main form. The data in the subform is linked to the main form by using the ID of an individual. If I select an individual from a drop down box I can requery the listbox (which contains the key data I want displayed) on the subform...

I would appreciate some help with a little problem that has occurred with a financial report (a statement for an individual service user) I have created. The main report shows payments made. PROBLEM 1 - if there are no payments I cannot get the textbox that calculates the total payments (in...

Hello everyone I'm sure this is quite straightforward....... I want to carry out a calculation on a main report form with data derived from the report itself (Total Amount from Receipts) and from a subreport contained within it (which provides total costs chargeable to the individual). The...

I have a make table query where I have a calculated field called Charge. I want to format this data item as currency so that when the table is created the field format is defined as currency. The current syntax in design view for the variable is: Charge...

I can't get my head round this one today! What's the syntax for double clicking on an item in a listbox to move to that record in the form? Current procedure produces a syntax error (missing operator) in query expression "[LocationID] = ' : Private Sub List0_DblClick(Cancel As...

I have an application that has been installed in dozens of locations successfully. However, there are one or two sites where the application, once installed, doesn't start up correctly because of missing libraries, allegedly. When I try to get to the References under Tools in the VBA editor...

I posted this request in another thread and it has probably got lost now, so have resurrected it as a new thread. I use drag and drop in a project I have been working on, generated from the guidance given on the Microsoft site. It works very well between forms by combining the mouse move with...

Using a pop-up form I am trying to select specific records (Child Service Users) from a list box (called Childlist) and then update a particular field (Dateended) in the table (tblServiceUse) based on the date selected in a text box(txtDateServiceEnd) on the form. Using the following code the...

I am trying to use the following query to generate a variable in VB: strSQL = "SELECT Count(tblChildAttend.ChildID) AS CountOfChildID " strSQL = strSQL & "FROM tblChildAttend " strSQL = strSQL & "GROUP BY tblChildAttend.[Service ID], tblChildAttend.Date...

I am trying to use drag and drop to select an item from a list box on a subform and drop it into a textbox on another form. I can't get the data selected by clicking to remain with the mouse as it moves across the subform towards the other form - it just continues scrolling down the list. When...

This is driving me mad! I have a list box on a form that should provide a complete list of services that an individual is involved in providing. The SQL used is: SELECT tblServices.[service start], tblServices.[service name], tblServiceLocation.[Location Name], tblServiceRoom.Room...