Search results

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

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

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

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

Hello, I've created a DB with seperated Frontend and Backend (FE/BE). The table "Users" (stored in BE) should be consulted when a user opens the FE and tries to log in. This isn't a problem, I've written a login form and connected the table to my FE. However, the problem is that I want my...

Hello, I've created a field called "WeekHours". In a continuous form (detail section), it displays the working hours per employee. To calculate this, the function "TotalHours()" is called under the "Control element source" of the textfield properties. Note: I'm not sure if this is the correct...

Hello, I have created a continuous form with a query as record source. The field names of this query are being displayed in my form header, while the detail section of the form contains all records. One of the fields ("Mark") contains a number from 1 to 10. I wanted to change the records who...

Is it possible to obtain information (in VBA) about the (exact) location of the currently opened mdb-file? For example: C:\Database\Example.mdb If so, how? :confused: All advice is welcome, thanks!

I would like to use VBA-code to check if the input of a table field matches a specific format. The main formats are: only digits and only characters. Example: The input check is: only digits. A table field "Phone Number" contains the value "12345678". VBA identifies this field only contains...

hello, I want to import a .csv file into Access 2003 using VBA-code. However, the data is being stored in the first column, separated by the ':' mark. Every record is one row. So, only column A has been filled with data in the .csv file. My 2 questions: Is there an Access function for...

Hello, I've created my own login procedure for an Access application (Access 2003) without using a .mdw file. Users can fill in their username and password and the program will check in a table if the user exists. If so, dependent on the assigned usergroup (also stored in a table) the user will...

Hello, I have written code in VBA-Access to open a blank Excel sheet and fill it with data. I am also able to change cell colors and the thickness of cell borders. However, now I would like to disable the grey cell borders which are shown by default in the sheet. In other words: the sheet...

Hello, I've converted an Access 2.0 Database to 97 and now the import function doesn't work properly anymore... (under 2.0 it works fine) The current vba-code I use for importing a (no-extension) file into a table named "data"...

Hello, When I start my Access application I've created a login form. It connects to an employee-table and checks the username and password that's been filled in on the form. According to the user group (also stored in the table) I've created VBA-code to show or hide bars and menus. I'll show...