Search results

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

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

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

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