Search results

I understand the root of your sarcasm, but i really cant let my users access the tables directly because they will change and exploit it to their advantage. It is an integrity issue. And i dont have a budget or expertise to purchase an SQL database and come up with a front end back end thingy...

I have no mainforms and subforms. I am only using 1 form which is not linked to any tables, it just consists of textboxes and combo boxes. This is because i dont want users to key into the tables directly. I want values keyed into standalone boxes and then use Sql to insert values into the...

Hi, i am writing an onclick event vba which insert values in my form to 2 different tables in one click. A main table and a subtable. The subtable is linked to the main table by a field called MainTableIndex and the main table generates the Index by autonumber. My question is how do i...

Got it. Thanks ruralguy!!

can anyone help? i lost the local administrator password. I want to reset it but the administrator does not show up under user accounts in control panel. i have access to another account also with admin rights but a different user ID. its a local pc, no network settings. Thanks.

What is the diff between a recordset and a DAO.recordset?

Thanks. I will try it out to see if the form loads faster using this method

Hi, i have written a function using vba in one of my form but i want it to be available for use in other forms i created too. How do i do that? The function is shown below. Public Function GetShift(StaffID As Long, InputDate As Date) As String On Error GoTo Err_GetShift ' Declare variables...

Which is better? having multiple Dlookup statements or using multiple recordsets in the vba statement?

Anyway, just to make sure this thread is still consistent with the VBA category.... While i am figuring a new way to organise my database, anyone can help with my original problem for the looping of SQL statements?

Thanks for the inputs Wayne. I am still having trouble picturing how the whole thing would work. Especially the form handling part. So under the tblEmployeeSchedule, the Schedule is - String ----> 2001111002222...... If there were changes to the Schedule, i would need to change the whole...

Another operation i need to incorporate is shift changes. My staff from time to time change shifts with each other. i want to be able to enter and display the changes too. Also there are cases of staff taking leave. By redesigning it this way, how do i incorporate shift changes to the database?

Hi Wayne, Thanks for your input! It is certainly a new direction which i can look at.

I want to use VBA because i can enter the data with just a click of a button on the form. I used to be doing it manually and its quite a tedious job keying in like 35 rows of data with 7 columns in each row. Also there is the problem of human error when keying in the shift pattern which cycles...

The table is not properly normalized, that i have to admit. I am still working on re-structure the tables and database. Basically the table holds shift schedule information for 6 of my shift staff. [Date]-Date of the shift [S#1]-Staff no 1. [S#2]-Staff no 2. .... etc What i am trying to...

I would like to start with the SQL part first. I have tried using For.....Next for it but i keeps giving me syntax errors.

Hi, i need help in condensing the following vba statement, i have a total of 35 sql to insert. How to i use the Do...while or For... Next to shorten the statements? SQL1 = "INSERT INTO tbl_shiftPlan([Date],[S#1],[S#2],[S#3],[S#4],[S#5],[S#6]) VALUES('" & InsertDate & "',' ','...

How do i program a macro to insert dates into a date field in an increasing sequence? example. ID Date 1 20/5/2008 2 21/5/2008 3 22/5/2008 ..........