Recent content by Bee*

That is SO close, the only problem is the titles in Row A are counted as data and therefore get imported as such, and then the import process complains that I don't have a column called F1, F2 etc. Is there an option to get it to count the title rows as titles?

Hello, been working on automating some formatting in an excel document via an access form. My code so far is thus: Private Sub runFiles(fileName As String, fileMonth As String) Dim xlApp As Object Dim xlBook As Object Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True...

Muchos gracias!

Hello, I need to create a general date field that takes my field [LogDate] and adds 9am to it (i.e 9:00:00), so that it basically shows 9am of whatever date it happens to be for that row, such as '12/03/2011 9:00:00' I've tried but it only outputs as a string. Is there a function that I can use...

Hello. I have a sub-form within a form in which the user enters data in various text boxes and a "Save" button that executes SQL to insert the data as a row into a table. The main form displays this data from the table row by row. Is there a way to automatically refresh the main forms data...

Thanks very much for that code, works a charm. The database automatically opens when the user logs in in the morning and records their log in time (on Form_Open sub). Then when they shut windows down last thing at night, the database will automatically close and records a log out time too (on...

Hello again, sorry for creating a new thread so soon. My form contains only 3 buttons and has no control box so that users cannot close it. The purpose of the database is to record their login and logout times when they start and close windows. As the db needs to remain open up until they...

Thanks for the code Linq! Unfortunately I have buttons on the form that the users use to lock their workstations with and the buttons aren't responsive at all. I think this could be a lost cause right now :-( Your help is appreciated nonetheless!

Hello. I have a database that is used to record the log in and log off times of staff at the office. The functionality of it I have down to the T. However, is there a way to just have the main form display by itself, rather than from within the access application? I have the form to open on...

I have two tables. Table1 has two monetary value fields (both set with auto decimal places) and table2 has one monetary field. Then I have an append query which appends all data from table1 to table2, except for the monetary fields which are added up and then appended into table2's single...

Hi, I have a question regarding a form I'm trying to build. Its a typical form where I add data to a table. However, I basically want this form to open with all the fields blank, so that the form defaults to the blank final row of the table. Therefore the user can enter data from the word go...

Hi, I have a question regarding a form I'm trying to build. Its a typical form where I add data to a table. However, I basically want this form to open with all the fields blank, so that the form defaults to the blank final row of the table. Therefore the user can enter data from the word go...

Hi, sorry if this has been covered before, I am a new guy around here. I have two tables in a select query, both with a code field and a monetary value field. The codes are linked. This query is to show the variances in the values of each table as they are meant to have identical codes and...