Create a table with data that does not change. Create a table to use with your statistics. Dates etc, stats. Then run a query using both tables. If the data...
I am receiving a syntax error on line one and 20 expected end of statement or ). Just so you know what the I am trying to achieve I have uploaded the...
Hi, Can someone explain hoe to create an "array" field in a table. What I need is a name field in which 1 to 5 names may be entered. I know I can create name1,...
Thanks Neil got that to work correctly also was missing the "Function" after public. So with that corrected it compiled fine however when putting it on the...
I don't know about anyone else but can you be more specific? Break this down. Name1, Name2, etc. Set up the scenario. (Embedded image moved to file:...
Your solution should be pretty simple. Break the equation down into simpler equations. I suspect that Brett has your problem pegged with a data type ...
Hi, Does anyone know how I can move fields froma combo box to other fields on the same form? I have a combo box made up of FirstName and LastName On Exit I...
I have successfully used the follwing command to fill a table: BULK INSERT [OrganisationsIMPORT] FROM 'c:\OrganisationsCSV-YN.csv' WITH (FIELDTERMINATOR = ',')...
... Eileen, I didn't see a response from you when I asked you to carefully check which fields are text and which numbers (or are supposed to be) To me it looks...
In MS Access 97 I loaded the Microsoft WebBrowser and ran it using the lines below. Option Compare Database Private Sub btnGoBack_Click() On Error Resume Next ...
Dear All, Wondering anyone knows how to control the spacing of the charactors within a control? Because when I right click on the control and select Size,...
... Hi Arnold, you have to have two controls selected to get those other options ... otherwise Access has nothing to compare with. ... There is also commands...
You cannot create an array field in a table. You must either concatenate the fields into 1 field or use Name1, Name2, etc. but the real answer is the...
assuming that the cbo box has 2 columns for first,last A. have the other text fields reference the combo box columns in the field properties txtfirst...
I have a combo box which has a recordsource as a pass-through query against sqlserver database. After each update, I'd like to refresh this combo box so that...
I am sorry to be asking such a basic question, but I am not skilled at computer technology and need asistance. I am building a database in Accesss 2000 of...
You need to put in an OLE field in your table. then link your image to the table. You can then put in in the field list when creating your form (Embedded...
I've run into this when linking tables that are in our ERP system. When you establish the link to the table, if you don't get the "indexed" fields exactly...
... KC, I have a demo on my website that will show you how to used linked pictures in your database. Just follow the link in my signature at the end of this...
Hello everyone. I've recently acquired a database program from a company--a home warrenty tracking database--to that I have to now support. It was built...
Storing pictures in your database can cause LOTS of problems. Check out http://www.rogersaccesslibrary.com/download3.asp?SampleName=Pictures.mdb for an...
Ray, The error message you are describing usually occurs if your code goes to open a form/report and the opening is cancelled. For example. I open report...
I am a newbie to Microsoft Access. I have a database that was done in 97. The organization wants to convert the database to 2000. Can that be done? If so, what...
In many instances, simply opening the OLD 97 databases in Access 2000 will automatically convert tables, queries, etc. However, some code (if you have a lot of...
... Just open it in Access 2000. It will ask you to convert it as it opens it. Brett ... Outgoing mail is certified Virus Free. Checked by AVG anti-virus...
Hi Brett, I'm sorry for my wrong interpretation; what I actually want is the spacing between the charactor within a control; not comparing with the other...
Forwarding Data to field!!! I would like to create an option that would allow the user to enter the same company info into another table that would contain the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
