I currently have a phone number field with this input mask -- 000\-000\-0000
When I try using this field to enter data I get an error message saying that I've entered too many numbers for t...
Is it possible to lock some/all icons on toolbar and menubar for a form?
What's the easiest way to append fields to an existing table? In Code.
How do i convert a *.mdb file to *.mpp file automatically. I need a tool which can populate the feilds of tables in Access *.mdb file to Project 98 and save it as *.mpp file
How can you import a fixed-width text file by using vba or possibly SQL statements?
Thanks,
amesg
I am writing a program that inputs data from a diskette, the disk can only be loaded every five days. How can I change the FileDateTime after reading the disk? Short of editing the file.
I have a user that is doubting my system because of stupid runtime error 2467 (refers to object that does not exist) The error happens every second time certain forms are started.
I have code...
I want to distribute an Access97 database with his own Setup Installation. I didn't use "Setup Wizard" from "ODE Tools", because I need to go into source-code to insert keywords, pwords and s/...
I Know there is a way to build tables in Visio and transfer it over to Access. Does somebody know how. It sets up your relationship for you.
Is it possible to calculate the number of days between two dates but only counting Monday to Friday. I am constructing a hire database where items are not charged at weekends. If, for example,...
I have tried to create a progress meter in Access with little success. What I wanted to happen was to set the time interval to 300 milliseconds, then have the progress meter run on its own wh...
hey List,
I'm trying to use the dbengine.setoption "dbMaxLocksperFile",8000 to adjust the registry settings at runtime in acces 2000, however I cant get the code to work. Do I have to add t...
Good morning
I hava a multi-year/tables invoice history database. Display of an invoice follows typical example found in all books, a Form with a continuous subform to display the produc...
My Access table has a "memo" field type containing product description, which includes imbedded new lines. User enters data using Access form, new line using Ctrl-Enter, new paragraph using Ct...
Dear Expert
How do i do an SQL query that will search through a database and return all data that match at least one of the variables being search. The query must also sort the data into orde...
Greetings To All.
===========
I have several genalogical databases with thousands of records.
Today, for the first time, I encountered the error message:
"File sharing lockout exceed...
I have a subform datasheet, with the following columns...
Category Product Price
Category and Product columns are both comboboxes. The rowsource for Products depends on the selection ...
I am writing a code and using on error goto errorhandler
and in the errorhandler: I have a msgbox to the err.number. The strange thing is that the program doesn't have any error (or at least ...
I'm desperate here :(
I'm creating forms during runtime.
I want to make them hidden.
I tried using the following code for this (Run from a form called test1):
DoCmd.SelectObject acFo...
My database is loaded on a computer with access97. One of the forms uses the common dialog control.
Everything was going along nicely when the PC's hard drive crashed. Office 97 was reloa...
hi experts...
i use the trim and chr(13) commands in my access program....but when i run it the following error will come out...
'Can not find project or library file.'
can somebody t...
I have a database that i had up online. Recently I downloaded it and although I can open it and it appears ok in access if I try to view its contents through a cold fusion webpage locally. I g...
I have written a helpdesk database and am just putting together the stats report. To track number of calls open at the end of each day, I need to keep a running sum of all the calls closed pre...
Using access98 on NT machines over a stable network, any suggestions how many concurrent users would be safe (I currently have about 50 users, say 20 concurrently)?
How do you put in a carriage return inside a textbox on a form or report? I am formatting an address and want it to display in one textbox but on seperate lines. Thanks
