Hi! When the query is like this there is no problem This works: TRANSFORM Count(Aktivitet.ID) AS AntalförID SELECT Aktivitet.region, Sum(Aktivitet.antalMän) AS [Antal Män], Sum(Aktivitet.antalKvinnor) AS [Antal Kvinnor] FROM Aktivitet GROUP BY Aktivitet.region PIVOT Aktivitet.aktivitetstyp But when I add this line I get into trouble...
Here is my query: PARAMETERS ... TRANSFORM ... SELECT ... ... PIVOT Mytable.type In ("Other","Info"); This is a cross query and I need to set all the column headings with this row: PIVOT Mytable.type In ("Other","Info") and now I have hard-coded the headings, Other and Info. But I want to do this dynamically. So what I want to do is ...
I need to communicate with a bar code scanner connected over a serial port in Microsoft Access. In older versions of Access I was able to use a wrapper around MSCOMM32.ocx that no longer seems to work. I can't use wedge communication because I need to use ACK/NACK which is only supported through the RS232 interface and I need to send m...
I have a database for tracking customer purchases over history. One of my forms allows you to search for a customer name, and a subform displays all recent purchases. I have a total of 474 customer records. I am tracking a total of 2119 purchase records. The BE and FE are already split, which may be slowing things down, but is needed...
I am using Access 2007 with a pass-through query. The data values that I am retrieving are from a bit column (0, 1) but when the pass-through query runs the data that is returned is either 0 or -1. I am calling a stored procedure on my SQL database for this pass-through query, this stored procedure works and returns the positive bit numb...
I have a dropdownlist that has 4 columns but only 3 are 'visible' the first one is an ID, and after update I have the following code run. DoCmd.SearchForRecord acDataForm, "new_order_thingy", acFirst, "[OrderID] = " & Me.Combo112.Column(0) This used to get the record pertaining to the OrderID, I am not sure what I did but I somehow br...
I load 10 tables from an ACCESS 2007 file database. IS their a way I can get the column names into the dataset or do I have to rename each column? I am using Visual Studio 2008 in VB.NET. I would like to reference the columns in the code by the name and not have to use an index I just went ahead and added the following code for eac...
Basically I work for a dining services company that has a menu database that we use for each week at multiple locations stored in a Microsoft Access 2007 .accdb file. I'm trying to develop a PHP application on shared hosting so that the .accdb file can be uploaded and queried as to generate and store HTML menus for the week based on the ...
Hello. I've been trying to connect to a MS Access 2007 database through JDBC. My JDK is JDK 1.6u18 64-bit and OS is Windows 7 64-bit. But problem is I am unable to create a DSN using Windows\system32\odbcad32.exe because it doesn't show ODBC drivers for MS Access at all, it's only showing drivers for MS SQL Server. When tried to click ...
Hi All. I have problem with Microsoft Access Database connected via ODBC to Postgresql database. Filter dialog - for filtering data using multiple selectable checkboxes: doesnt work. EDIT: Doesn't work: I'mean there is no checkboxes to select. There is only options for sorting A-Z and Z-A. How to fix this? I can sort data, I can fi...
I made query that accepts two parameters. Now I want to use that query in the expressionbuilder for a textfield in a report. I want to pass the parameters in the expression. How do I do that? The code for the query in the expression is like [queryname]![returnfield]. ...
Hi, I'm migration Access 2003 to 2007. There are a lot of linked table from Oracle. I create a ODBC point to Oracle instance, then in Access I link all table through ODBC. I use this code login, so the "Oracle ODBC Driver Connect" dialog box would not popup to ask password: strConnect = "ODBC;DATABASE=" & strFCPD & ";DSN=PBRIS;UID=...
I have an Access table with two columns (ID and Active) with data like the following: ID | Active ------------ 123 | 0 124 | 0 125 | 0 123 | 1 314 | 1 948 | 1 I want to select the distinct records that have a unique ID (that only exist once, not just the first time they exist), but I also need the Active value. If I do a SELECT DI...
How do you put a combo box in an Access 2007 Report so you can select a record ID and it will bring up the record in the report so it can be printed? ...
I'm getting a formatting problem if I use more than 10 UNION ALL statements in my VBA Code. If I use 10 or less everything works great. What I'm trying to do is combine 12 worksheets (Excel 2007). I have a numerical column called SC that turns into string and date if I have more than 10 UNION ALL. If I try to use ROUND with more than ...
I have a Access database with 3 tables involved in this problem: People, addresses, address_person People has an pID (person ID), Addresses a aID, and address_person has a person field and a address field. In my form wich displays data about the person I have a listbox with the following source: SELECT address.ID FROM address INNER J...
When I try to run any update query in Access 2007, I get the message that action blocked because an available .... What can I do about this? ...
hi how can I open an MS Access 2007 database with a password in c# ? I have tried this: Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\BioDB.mdb ;Password=1966;"); but it doesn't work. ...
Late breaking news! If I manually create the new record with SQL and then open the form in edit mode using the code below, it works. I would still like to know what the problem was before, but at least I can get on with my application now. Form1 Form1 is bound to Table1. Table1 has an ID field. Form2 Form2 is bound to Table2 joine...
Hi All, I have a huge database (800MB) which consists of a field called 'Date Last Modified' at the moment this field is entered as a text data type but need to change it to a Date/Time field to carry out some queries. I have another exact same database but with only 35MB of data inside it and when I change the data type it works fine,...