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

Is that on the open form for the database?

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

Thank you very much

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

Guys, I sorted out.. I came up with this is code Private Sub Command2_Click() Dim cnn As ADODB.Connection Dim strConn As String Set cnn = New ADODB.Connection strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source= C:\Users\Manuel\Desktop\Backend.mdb;" cnn.Open strConn...

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 tried to simply my question. I deal with high volume of data so i want to keep yhe info in the back end dbs. I have 7 back end databases with one table in each. I have a front end db that contains 7 linked tables linked to the back end databases and queries and forms. My users...

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

Cool, i will do it tomorrow.. I go to bed now.. thanks for your help

Basically I found the below code in the internet to create a login form. When we get to DoCmd.OpenForm "SBUForm" I would like to pass the name of the department to the SBUcbo combo in the SBUForm based in the value entered in the combo CboEmployee. so I need to use a Dlookup. CboEmployee is...

IDEmployee comes from a table

nope it is a autonumber

I get this message Runtime error '3075': Syntax error (missing operator) in query expression [IDEmployee]='

Thanks for your help I have entered this code on my Logon Form DoCmd.OpenForm "SBUForm", acNormal, , , acReadOnly, Me.CboEmployee.Value and I have entered the below code in the Form's (SBUForm) On Load event Me.SBUCbo = DLookup("[SBU_Name]", "Tbl_Employees", "[IDEmployee]=" & OpenArgs) But...

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

thanks John. I knew about the totals query but I missed to use an iif function

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

Cool thanks it works now..