| Thread | Last Post | Replies |
|
| ASP Login Failure - Database Password | 31 Jan 2005 02:06 GMT | 6 |
Thank you for taking your time to read my question... please offer your knowledge it will be appreciated! I'm writing a ASP Web page to access a Access Database that has a Database Password set. If I remove the password I'm able to read and
|
| Securing A Folder On A Server | 30 Jan 2005 22:13 GMT | 7 |
Can anyone give me any advice on how to secure a folder on a network server so that documents in the folder can only be opened through an Access database or by the database admin. I need to store MS Word docs in a folder on a network server. The database admin will save the docs to ...
|
| How to copy existing table structure to create empty temp table? | 30 Jan 2005 21:45 GMT | 1 |
DoCmd.CopyObject copies data, but I only need structure. I'm trying to clone several tables in my Access 2003 mdb. The goal is to link to a series of Excel spreadsheets and then run various action queries against the data in the linked tables (to massage and import it). Since I
|
| How to make composite unique index? | 30 Jan 2005 21:44 GMT | 10 |
I understand it's possible to make a composite Primary Key by holding down the control key and selecting multiple fields, then right-clicking and selecting Primary Key. But I've heard that's not a good idea. What I want to do is use table constraints to ensure only unique ...
|
| Dim X as long ==> What is the value of X??? | 30 Jan 2005 21:20 GMT | 3 |
What is the value of X immediately after declaring the variable? I thought its value was Null. However, I am unable to assign a value of Null to X...
|
| New; going from flat to relational | 30 Jan 2005 20:23 GMT | 1 |
I have had many years using flat file databases (File Express from way back) but am now at a company where a relational database is needed and would carry us into the future. Since I know some basics on databases, have VB Pro programming experience over the years, and I know ...
|
| Connect to Internet from Access? | 30 Jan 2005 20:21 GMT | 10 |
How is it possible to load raw text from an Internet page (html-format), to MS-Access? My questions are: How to connect to the page?
|
| ADP Ready for Prime Time? | 30 Jan 2005 19:11 GMT | 26 |
A while back I posted a message re. using an ADP file with a SQL Server back end as opposed to MDB file with linked tables, thinking that the ADP file would be less problematic. The input I got was that the ADP would be just as, if not more, problematic; that ADO is far more ...
|
| Not able to add record | 30 Jan 2005 17:51 GMT | 1 |
My switchboard provides buttons to open several forms in Edit Mode. Some forms allow adding a record while others do not. The forms that do not allow additions are forms that contain a subform, plus they are populated through a query. Otherwise the properties to allow edits, ...
|
| Visual Studio Tools for Office ? | 30 Jan 2005 17:09 GMT | 2 |
Can anybody explain me whether MSDE is or is not included in Visual studio tools for Office ?
|
| calculating a percent of total in a query | 30 Jan 2005 16:46 GMT | 2 |
I created a query in which I have grouped data by City. I wish to calculate the percent of each value, e.g. City/(Total count of all Cities), in tbe next column of the query. I can't seem to write the correct expression due to the "groupby" needed to group the city count
|
| Sending selected items from listbox to report | 30 Jan 2005 14:42 GMT | 2 |
From a listbox I'd like to send only selected items to a report. Items will include: OrderNr,Date,EmployeeNr from tblOrders ZipCode,City from tblZipCodes
|
| ListBox question | 30 Jan 2005 14:15 GMT | 1 |
On a mainform I have a listbox that retrieves data from tblAppointment. A popupform will record new appointments and when closed, update the listbox on the mainform. However, is there a way to have the listbox component in ms access
|
| Coding a switchboard so new forms don't pop open in new windows. | 30 Jan 2005 14:12 GMT | 1 |
I am looking to set up a switchboard that doesnt have new forms open as pop open in new windows like they do as the default I am looking to make my own switchboard where I have the list of forms I can open on the left and a box on the right where they open into.
|
| Cascaded update/delete box unavaible. | 30 Jan 2005 13:58 GMT | 2 |
I have a relationship that I createed with a table and subtable in the relationship editor however the boxes to enable enforce referential integrity and cascading updates and deletes are disbabled. I want to enable cascading deletes.
|