Search results

Something went crazy in my settings somehow. Before I had my Grid X and Grid Y set to 5 (resembles light dots) and it has been set like that for nearly 4 years - today I open it, and I have thick, heavy grid lines. I reset the X and Y back to 5 and I get my old gridlines back, but the heavy...

Another Question about MDW files... What steps do I need to take to get this to work: I have an Access 97 db and an Access 97 MDW file that were created on another user's machine. The mdb is locked up and I cant get into it with Access 97. (When I try opeing it on its own, I get the "You dont...

A client of mine has an Access 97 db and an .mdw file for security. I am trying to open it in Access 2000 on my own office computer using a shortcut specifying the db location and the the workgroup file on my local desktop. When I click the shortcut, I get this error: "Cannot open the...

is this possible? I have a list set to multi-select. I would like to programatically clear this property, but it is read only... Any suggesstions?

I would like to have a form where the user can place picture box images in any part of the form and have the form save the placement of the boxes. How could you do this? Where's a good place to start?

I have a column in one table where all the records have either 2 or 3 spaces that trail. I try using Trim on it, but it doesn't seem to have an effect. Trim works in other areas of my application, but on these records, something seems odd. Is it possible that these are special 'placeholders'...

I have a string that includes '(' and ')' characters - Access does not seem to like this. for example, I have a string:Abacavir (Ziagen)__ if I paste it as a criteria, Access changes it to: Abacavir ("Ziagen")__ I have tried 'Abacavir (Ziagen)' - but with no luck... Any suggesstions?

I have a bound form and I need to grab values of a couple controls on the form load event- unfortunately, the form hasn't fully 'loaded' when I try to call the code and get errors. I have tried the code in the form_open, form_activate, form_gotFocus - none of them will work. How can I open a...

is it possible to have a specific row of a list box highlighted on the form load event? How would you do this?

I have an XML string that is stored in a Memo field and when I retrieve it, I only get 255 Chars returned. I have read that older versions of Access had a problem with < > in the memo field, is this the same problem in A2K? I am querying the xml table I have and display them in a listbox...

How would you export Invoice information to Excel with multiple line items and then do a subTotal of Line Items? I know how to export just the Invoice info or just the line items, but I need something like an access report that contains a subReport - only in Excel I have 2 queries - one for...

I have a report that I send via email in rtf format. Is there anyway to make the file read only so that a general user wont go typing all over it?

I have a fairly complicated report - and I have approx 30 people using my app on different machines. Everyone can view this report except for one person - everything comes up as '#error'. I realize this is because access doesn't understand the field name, but it works on 29 different instances...

I have a list bound to a query - one of the fields is a currency field. In the query, I can show more than 2 decimals in the result, but when used in the list, it rounds off the result to 2 decimal places. What can I check? thanks

I have an .mde FE that conntects to an .mdb BE. I use installshield to package this together as a distributable application. Just recently, a user asked if I could password protect the db. I know how to password protect the BE, but how do pass the password params to the BE from the FE on...

I have some code that programmatically links to different DB's, but it doesn't bring in the relationships of the linked DB. How do I import the msysRelationships table? I need to delete some relationships, but my mSysRelationships table is empty in the Front End

I have split my DB into a FE/BE. There are users using this system individually for their own companies - so I cant really get access to their DB I have 3 tables I need to straighten out that are linked to the FE. Table A has a relationship to Table B, but I need to delete that relationship...

This may sound kinda lame - but just thought I'd throw it out there... We should have a contest where a small project with basic requirements is defined and anyone who wants to participate would design and build an Access system to solve the problem. We could all judge the projects on coding...

I have a text box that holds a Customer ID. If the user selects a customer from the combo, it writes the ID to this text box. I want a query to use this as the parameter, if it is blank, I want ALL records returned - How can this be done? I know the query is easy if the user selects something...

Has anyone out there used any 3rd party tools to make an install package for Access? I want to put a license agreement form into the install, but not sure if the regulare vb package and Deployment wizard can do this.