Search results

I have a subform that is connected to the main form through the field INVOICE_ID. Now, I want to filter a combo box in the subform based on the current INVOICE_ID. For this reason I have included the following line in the WHERE clause: [Me]![INVOICE_ID]. I thought this works but evertime I...

Hi *, Currently, we're using an Excel sheet that we use for data input. The Excel sheet has the format: ____________________JAN________FEB________MAR GERMANY AUSTRIA SWITZERLAND Now, we'd like to use an Access database to save these records. The table I've already...

Hi * I have a report with 2 rows in the details area. The first row should be visible no matter what. The second row, however, should only be visible if the attribute it is supposed to display is not NULL. I attached a screenshot in order to make my point clear. As you can see, the first...

Hi there, I have a form that I want to be opened and insert one new record into the table. When the form loads, the following happens: 1) Create new record 2) Put a default value into a control element (bound text box) My problem is that Access does not save the record to the underlying...

Hi *, I have a hard time to generate a dynamic query. I want to have 2 combo boxes. (1) I choose a customer in combo box 1 (aka cboCurrentCustomer). (2) I want to show only projects which are related to the customer shown in combo box 1 (SEE SCREENSHOT) Now, I entered the following SQL code...

Hi *, I have a database that connects to a mySQL server via ODBC. Currently, I have 10 linked tables available. Now, I changed the underlying mySQL scheme and inserted a new table, which I would like to connect to Access! Unfortunately, I haven't figured out a way to do that in Access 2007...

Hi there, I want to setup my Access 2007 database with the new tabbed forms feature, i.e. I want most forms to show up fullscreen. However, some forms should be shown in a window. How can I set this up? Here is a sample that illustrates what I'm talking about...

Hi *, I recently found an Access database that shows a form at startup ONLY IF VBA is disabled (user has to click on 'Options' -> enable this content). Unfortunately, I'm not able to figure out how to implement this feature in my own database. I know how to setup a database with a static...

Hi there, I have a couple m:n relationships in a database. Now, I was wondering whether (1) to create a new primary key in the connecting entity or (2) to use the combination of the 2 FK as new combined PK. The attached screenshot shows option 1. What option would be better for good query...

Hi *, I'm in the process of developing a new internal project controlling. Part of the system is a (1) already existing system and (2) an Access front-end. The already existing system uses a MySQL database. The ERD is attached. Now, I need to integrate both systems and I have a couple...

Hi *, At the moment, I'm working on a data entry form that lets the user input data in a calendar format. I attached a screenshot of the design I'm thinking about. As you can see, I would like to be able to present a view of the current month. Here the user should be able to directly insert...

Hi there, I got a little data transformation problem: I have got a source table: ID 1 2 3 1 x y z 2 xx yy zz That I wanna transform to the following format: ID ID2 Comment 1 1 x 1 2 y 1 3 z 2 1 xx etc... The problem is, that I need...

Hi *, OK, still new to Access so I apologize in advance if that is a dumb question ;) I have a table "survey" where I wanna store number values (0,25,50,75,100 respectively). The user is supposed to use a form to input the data into the table. For this purpose, he/she is supposed to use a drop...

Hi there, I'm pretty new to Access so I hope this question is not to simple/stupid ;) Ok, I have an Excel Worksheet that I want to import into an Access Table. The column headers are identical! The only problem is: - the Access table looks up a couple of the columns from other Access tables...