Recent content by kuipers78

Don't I have to split my single table column first to do that?

Hello, Is it possible to split rows of a single column into 2 (new) columns by using a query? Example: column A from a table contains 200 (unique) rows and the query divides them (dynamically) to column B and C with 100 unique rows each. Why would you do that? Well, because I want the table...

Thank you very much, it worked! :)

Hello, I've got two tables with the following field values: Table1, Field 'Planned Groups' 2 4 6 4 7 Table2, Field 'Total Groups' 1 2 3 4 5 6 7 8 9 10 Now I want my query to display the groups that aren't planned. So, the result of comparing the fields of both tables should be 1, 3, 5, 8, 9...

I figured it out myself. The records of a continuous form can be requested by using the 'Me.Recordset' command. So, if I want to know the value of the second record I can simply put in my VBA: "Me.Recordset.Movenext" That's all...

I've created a continuous form with a field called "Age" in the detail section of the form. The continuous form displays the records of a table called "Children", which contains 5 records. I want to request the age of all children (seperated) from the fields in the form, but when I refer to...

Hello, I'm trying to export data to an Excel spreadsheet (using VBA), which usually works fine. But now I have the following problem: When I try to export a date, Excel defines it's own field property and mask to it. And this means a date notation I don't wanna use! So, I've tried to convert...

I'm sorry, forgot to mention it. The error message is (when using more than 30 characters): Error 3011 during execution: The Microsoft Jet-database-engine can't find the object [Name_of_tab]$[Columns]. Make sure the object exists and the name and location are spelled correctly.

Hello, I need to import a specific tabsheet from an Excel file into my DB. I'm using the following method: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "[Name_of_Access_table]", "[Location_of_Excel_file]", False, "[Name_of_tab]![Columns]" This works fine, but only when the...

Anybody??? :confused: Is this really that difficult or didn't I make myself clear enough?

Hello, I've created a database where photo-information will be stored. Every photo is linked to one or more categories. The categories are stored in a seperate table. Because a photo can be linked to more categories and vice versa, I've created a table connecting categories and photos...

Yeah, now it works! Again, thanks a lot Bungle! You're great! ;)

Allright, do I have to create this pass-through query among the query objects or in the VBA-code? How do I link it to my BE without adding tables to it? I have really no idea... :confused:

Allright, it sounds very good but despite your explanation I still find it hard to understand how to create this. Could you please post or email an example DB? If you don't want to (I can understand that) I have a few more questions which I hope you are willing to answer. Thanks a lot for your...

Looks like a good solution to me Bungle, but could you be a bit more specific, please? How can I call a BE query with code in my FE? (that's what you're suggesting, right?) :confused: