Search results

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...

Ok - so I found the 'Insert subdatasheet' in the datagrid view of the Invoice info query. I can expand the record to show the line items that correspond, but when I export the query to excel - it just exports the main Invoice info query - not with the subdatasheet details. How can I get it to...

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

K - did a better search here and found some good code to try - hopefully it isnt painfull as it looks!

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...

maybe thats a better idea - create an application that involves many of the questions asked here. I was thinking that administering a web page would be a bit of work. Not exactly sure how this could all be pulled together

no vision yet - just the idea :) I would like to see something that involves a few every day problems and maybe a few head scratchers. I am up for anything - if someone has a good project idea or a game plan to follow, they could just suggest it in this thread. I could look at throwing...

well maybe contest isnt the right word - more like a comparison of resulting projects - it would be neat to see how people solve the same problem

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...

thanks for the reply I tried this code: If Me.FrameCust.Value = 1 Then 'all records stDocName = "Accounts Receivable" DoCmd.openReport stDocName, acPreview Else 'by customer stWhere = "[CustID] = " & Me.cboCustomer...

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...

Ahhhh - the good ol 'error accessing network I had this problem a few months back and contacted Microsoft Support(Canada) - they said that they really didnt have a fix for this - only one other person had contacted them prior to me about this error. This is thier response (and it works)...

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.