Search results

Hello, I was wondering if some can help with a little problem I have. I have a MS access 2007 database with different tables. One of the tables is linked to a SharePoint List. I have a form with a record source using the table linked to the Sharepoint list. I would like to change...

Hello, I was wondering if you could help me with a little problem I have and see if you guys know any solutions. I have a continuous form, when I do a right click on the form I get the shortcut menu with Form view, Design view, Layout view, copy, paste, etc.. as you know. If a I go to a text...

Hello, I have 7 queries with the same information but the fields have different names. ( Info comes from different systems and the names of the fields are different). For instance, In query1 I have a field called Prices In query2 I have a field called UPrices In query3 I have a field called...

I am trying to run this code from an access db to import a txt in a different one. Do you know why the below code doesnt work? Thanks Jose Private Sub Command0_Click() Dim cnn As ADODB.Connection Dim strConn As String Set cnn = New ADODB.Connection strConn =...

Hello, I have a database split between back end and front end. The back end contains just one table which is linked to a linked table of the front end db. The task I perform is that I open the back end db and I delete the table in and I import a txt file creating a new table that I name with...

Hello, I was wondering if you could help me with a little problem that I have. I have the following crosstab query TRANSFORM Sum(Qry_Calcs3.SumOfNet) AS SumOfSumOfNet SELECT Qry_Calcs3.[Fund Type], Qry_Calcs3.[Fund No], Sum(Qry_Calcs3.SumOfNet) AS TotalDays FROM Qry_Calcs3 GROUP BY...

Hi, I am trying to pass a value from a combo box CboEmployee which is in a form called LogonForm to the combo box SBUCbo which is in a form called SBUForm. The idea is when someone selects his/her name is the CboEmployee I can do a dlookup to obtain the department where the person works and then...

Hello, I have a little problem and I dont know what approach to adopt. Basically I have a table with the following fields: Dept, Error, Fund ,Customer, Number units, Cheque Value, compensation Type and Status ( Please the excel file that I have attached ) I would like to create a query that...

Hello, I have a combo box with three fields: ID, Funds, Exceptions. These fields are linked to a query and the query has been created from a table called "DailyPrices". I would like to use the ID record from the Combo box to search for it in the table "DailyPrices" and provide me the information...

Hello, I have created a query with fund prices and fund prices variances and I am using a combo box to set up certain criteria in the query. The idea is that a user can select to see funds whose prices have varied 0%, 0.5% etc... This is my query: SELECT FundPrices_Qry00.Date...