apartain
Last Activity: Nov 19 '07, 11:39 PM
Joined: Nov 15 '06
Location:
-
Prohibit others from importing my tables
I thought my database was secure, but I didn't think about someone creating a new database and importing all of the tables, queries, forms reports and macros. Can I do something within my database to prevent others from importing or linking to my items? -
Need to learn MySQL...I think.
I use MS Access and have always wanted to create a web-based database. I now NEED to do so. Is MYSQL the correct program to learn, and if so, where do I go to learn it?
Is there a reliable and easy-to-use program that can convert my Access database to MySQL, or do I really just need to learn MySQL? -
I have split the database as well as the one-table test database which still ran slowly.
My PC has plenty of space and is defragged regularly. Also, the other users of the virtual network are all experiencing the same thing. We are all over the country from Connecticut to Arizona.
I just thought there might be something more I could do from within the database to make it faster.... -
They all have the field name "Work Order Number".
There are some other like fields such as date, ID, etc. but that's it.
How does a union query work?...Leave a comment:
-
I'm sure this is something easy to do, but I can not figure it out. I tried it in a query where I included the WO, labor, equipment and materials tables. Zero records appear. I tried multiple queries with WO and labor, WO and equip, etc., which seemed to work but then I could not join THOSE queries.
What I want is to view a report which shows only those work order numbers that had activity for that time period. There may or may...Leave a comment:
-
Troubles creating parameters for a report
My database is based on Work Order Numbers. If an employee enters labor, they must include the WO Number for it. Equipment, subcontractors, per diem and materials all must also have a WO number.
I have the following tables:
Work Orders
Labor (includes per diem and time entries)
Equipment
Subcontractors
Materials
I have created a summary report using the Materials table which lists... -
Sharing a database over a virtual network
I'm trying to share a database over a virtual network and it is extremely slow. I created a dummy database with one table to test it out and it is still slow, so I don't think it has anything to do with the size of my database.
If I am wrong, is there something I can do to speed it up?
Thanks,
Angie -
apartain replied to Sharing database creating error messages for missing or broken ref to mscomct2.ocxin Access1) Being a VBA newbie, where do I put this in the VB Editor?
2) Where and when will it run? I am assuming upon opening the database?
3) If the references are not intact, how do I proceed?
4) Is this something that is recommended any time I create a shared database?
Thanks!...Leave a comment:
-
apartain started a topic Sharing database creating error messages for missing or broken ref to mscomct2.ocxin AccessSharing database creating error messages for missing or broken ref to mscomct2.ocx
I placed a database on the server and all of the other users are receiving the error message:
Your Microsoft Access database or project contains a missing or broken reference to the file 'mscomct2.ocx' version 2.0
This is a virtual network and we are all running our own copies of Access.
I did use several ActiveX controls. Can anyone tell me what the other users need to do? Is there a download they... -
I did not know there is an ActiveX clock. I do know how to use the ActiveX Calendar control. Is it the same?
The code I referenced is directly from the Access help files for adding a "digital" clock feature to a form for a single text box. I need it for TWO text boxes, a start and stop time for an Employee Time Card database. Since I'm not familiar with VBA, I wasn't sure how to modify the code I downloaded to work for...Leave a comment:
-
BTW, I do not have a Seconds field but did not know which lines of code I could delete. Do I even need to delete andy Seconds code?Leave a comment:
-
Clock script
I wanted to add a clock feature to a form for both Start Time and End Time fields. I followed the instructions from the Help files to make the Start Time work smoothly. The Help files only gave the code for one field, however, and I need two. Following is the OnCurrent Event Procedure for the Start Time field.
All of my controls for the End Time clock feature are exactly the same with a "2" behind them.
... -
Sum/Rounding issues from subforms
In the detail of my report I am extracting a sum from a hidden subform via the following:
=IIf([Materials Detail for WO Overview].Report.HasData =True,[Materials Detail for WO Overview].Report!Text19, 0)
Where Text19 is the sum of the items in the subform.
I also need a grand total of the Text19's, but because of the conditional statement in the field recieving the result, I can not simply sum them up at... -
Can I control open forms of other users?
I have a database which manages employee time. I have created a macro which locks records so they can't be edited until I unlock them. This is so when I have accepted all time entries by employees and have submitted the information to Payroll they can't go in and add or edit records and mess me up. I need it to be manual because I submit to Payroll on different days/times.
The lock feature works, but what if an employee is in the... -
User-generated reports..can it be done?
I have been asked to set a database up so that the users can choose which fields they want to include in reports. Is this possible? Keep in mind the end-users know nothing about Access and would need it all very automated.
The only thoughts I have on the issue would be to create a form with all of the possible fields and a check-box for the user to select the fields. Then I would set the value of the Visible property for the fields... -
It is an error, but not in the macro, just in the message.
Thanks for that tip!...Leave a comment:
-
I do all of this via the macro interface because I don't know VBA.
I have the following fields, which have the Visible property set to No on the form, but the macro runs OnOpen of the form. If the employee has checked the Yes/No box to Yes, the fields become visible.
Address
City
State
Zip
Address Visible (Yes/No)
HomePhone (Yes/No)
Fax (Yes/No)
Birthdate (Yes/No)...Leave a comment:
-
I ended up doing it this way:
I created a new table named WkNo with two fields WeekNumber and Status. I then populated the table with week numbers from 1 to 52 for the year, and the status is either even or odd, manually input by me.
I then used a DLookUp function in a form to look up the record from the WkNo table where the WeekNumber equals the DatePart of the current week, returning the even or odd in the Status...Leave a comment:
-
Conditional macro is stopping after first action
I have a macro with several actions in it. They each have a condition. The macro seems to be working for the first line of action, but not for any of the subsequent actions. Any ideas why this may be and/or how to work around it?
Thanks. -
I had to do it in the form. I set the BeforeUpdate event property of the form to the name of my macro.
I then created a macro with the following condition:
[Cell_ID] And [BLDG_ID] Is Not Null
and the action to MSG "Invalid Entry"
the next action (same condition) to CancelEvent.
Now when you use the form to add a new record, Microsoft Access runs the validation macro...Leave a comment:
No activity results to display
Leave a comment: