I found this info on MSDN today. Was anyone else aware that VBA converted integers to long. I have used integers in my code where ever possible. Internal functions like on dblclick(cancel as integer) still use integers. I started programing when memory was tight now it seems my practice...
All of our service departments are grouped into 1 division and under the vision of our VP a service center was formed because customers should not have to know which department handled their request. Customers should see us as 1 department. All requests are routed thru the Service Center.
The...
I have xp-pro installed and have hours and hours spent in the updates sp1 and all the other patches-updates-fixes. Being a 56k user you can imagine the time I have spent. Now I want to install a larger harddrive in this machine and reuse the old one in another machine. Under win9x all I would do...
using CR8
Our new system each month creates a new database names it in format of mmyyyy and creates new tables and renames them in the same format mmyyyy. For last month it is 062003.mdb and a table name would be cd062003. My problem is how do I create a report that will allow me to report out...
In 1997 I created an Access database to log the calls into our Customer Service Center.
Being inexperienced, I placed the database on a shared network drive and placed a short cut for the staff who log calls, Usually around 3-5, I also have a front end that the various departments can access...
When I create a table I usually place a caption on the fields property sheet.
How can I refer to this in code
rst.fields(1).caption ???
tried properties but to no avail
TIA
I have a question on Database design. Lets assume I want to track equipment location information. The location can be at various buildings. Those buildings can have various floors that hold various departments that are located in various rooms Etc…
Currently I do something like this...
I posted this question last week and did not get a solution so I am reposting.
I have a database used to track attendance
The table uses occurstart to hold the date they first missed and occurreturn for the date they returned.
Example
empid Occurstart Occurreturn
123 6/1/2001...
I have a database used to track attendance
The table uses occurstart to hold the date they first missed and occurreturn for the date they returned. Example
empid Occurstart Occurreturn
123 6/1/2001 6/2/2001 all days in range
345 6/29/2001 7/3/2001 2 days in...
I have a customer service center where we log incoming calls into an Access database. After the calls are logged in we send the page to the staff via an alpha numeric pager. We currently use software provided by our pager company to send these pages. Based on the call we either page one person...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.