Search results

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

Thank you very much for your quick reply Bob! Never thought the solution could be so easy! However, this conditional formatting is a bit limited. I use a background color for my text box which isn't present in the pallet. Any suggestions how to define my condition a bit more specific, so I can...

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

You're great! Thank you Keith! :cool:

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!

Thanks for your reply Freakazeud! :) The IsNumeric-function works properly! Maybe I wasn't clear enough, but I don't want to check a new value that is being added by the user (this could simply be checked in the field properties of the table). The field values are already there (through an...

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

That's right! I just figured it out myself. It works the same as importing a .txt file, so I now know what to do. :D Thanks for all help.

Thanks for your quick reply! You are right, I can split the data into a new table using code, but the question remains: is it possible to split it WHILE importing? And secondly, how do I import a .csv file into Access? :confused:

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

Well, indeed my application uses one front end which is being shared by all users. I (almost) never change anything in the back end, because it only contains 'hard' data stored in tables. So, when I have to make a change I now open (exclusively) the front end and alter it. That's it, done...

You are right, I should have read the forum more carefully. I managed to alter the VBA-code so that I can block users from entering the database and kick them out (even with an announcement screen). This can be done by simply altering one field value in the Backend. :cool: Sometimes solutions...

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

Thanks, it works! :D I had to change the lines a little bit and got the following code: ExcelSheet.Application.WindowState = xlMaximized ExcelSheet.Application.ActiveWindow.WindowState = xlMaximized ExcelSheet.Application.ActiveWindow.DisplayGridlines = False

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

Yeah, I'm a dutchman too, so why do we make things so difficult by discussing in English? Just kidding of course, it ain't a dutch forum and otherwise John couldn't have joined our discussion ;) One more question (a little bit offtopic): what does 'sic' means??? Spelling InCorrect???

Thanx John! And thanx of course Namliam! :) Sorry, I should have read more carefully, but Access has hidden these features quite good... Now it works fine and I am very happy! Thanks again! :D

Maybe I wasn't clear enough, Namliam. I tried to say that all import specifications I have written are in the code I posted. I wouldn't dare to assume that this code is 'complete' or that there aren't other ways of specifying an import. Otherwise I wouldn't ask for it, would I? ;) You are...

I've figured out that Access wants you to define all fieldnames in the first .txt row, seperated by ';'. This results in 1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24 Furthermore, Access wants you to use the ';' symbol for all separations of data in the .txt file, so the '|'...

All specifications are written down in the code I posted.