Search results

Hi, I'm trying to dynamically get columns of data into a calander-like report. So far I have my data being formatted in the detail of the report - see below. The one hitch is that there are too many columns for one page and I can't get it to move onto the another page. It seems to format as...

I'm sending an email from Outlook through MS Access VBA. Does anyone know if there's a way to specify the location of the attachment. Right now it's just poping up in the in the middle of the email text and the people with screen readers are having problems with it. If I can put it at the...

Hi, I just added a new user to access this database. Set up an icon on her desktop. Copied and pasted the Target Path from another users icon into hers and I'm getting a message saying "database not found" 1. I've checked to make sure she has access to the folder where the DB is. 2. I've...

Hi, I've searched thru the forums, but haven't found any problem similar to mine. I'm trying to strip a field of spaces...certain fields have one space as the string and the code doesn't seem to recognize these fields. If str = " " the code doesn't recognize it. Here it is: str =...

Hi, I have code set up to loop add email address to an Outlook email. I populate the bcc. The users are stating that certain emails (about 2-4 emails)aren't getting sent. Out network guys are saying that they're not showing these emails being sent in their logs. They think it has something...

Hi there, I did some searching in the forums, but couldn't find anything on this issue. Does anybody know if I can search from my access database into a directory of word files and search each file for keywords? I'm thinking if the keyword is in the document I would check off a field in the...

Hi there, I need to use the createfield method which I can do, but I'm having a problem dynamically naming the fields based on users form input. Does anyone know if this is possible? Basically I have a form with a date range (2000-2005) specified by the user and when I run the report I need...

Hi, I searched the forum, but I didn't find anything on this. Is there a way to get record specific security with Access. I don't think there is, but wanted to know if anyone knew for sure. Thanks, Full Williams

Hi, I'm getting "Run time error '3251' Operation is not supported for this type of object" on the: If ctl.Value <> ctl.oldValue then line. I'm asking the user if he/she wants to keep the changes made to the form. If not then replace the changes with the old value. This code was working...

Hey there, Can someone take a look at my code and let me know if they see anything wrong. I'm getting a message that says: "Update or CancelUpdate without AddNew or Edit" Here's my code: Set db = CurrentDb Set rst1 = db.OpenRecordset("tblTable", dbOpenDynaset)...

Hi there, I'm having a problem joining a workgroup on a users machine. I tried joining a workgroup that I created and that's sitting on a server (Secure.mdw) and then I tried joining the System.mdw that's on the user's harddrive. With both attempts I'm getting an error message saying...

Hi, I've run through all the steps in securing my database on the network, however there seems to be a problem. On the computer where I created the workgroup I'm asked for a username and password when going through the shortcut and when I try to open the Database through Windows explorer I get...

Hi there, I have a table with 6 memo fields and I want to add all the memo field data to a different table with 1 memo field. So I have some vb code that pulls out memo field1 data then adds to the new table then pulls out memo field2 data and adds to the new table etc. For some reason the...

Hi, I'm trying to display addresses in a mail label report like this: John Doe 1234 S. Street San Francisco, CA 22102 My problem is that some addresses within my table have 9 digits and some have only 5. The addresses with 5 digits display correct while the address with 9 digits display as...

Hi there, Does anyone know if it's possible to call a Function from an ASP page? Any help would be appreciated. Thanks, Full Williams

Hi there, There's a lot of info in the forums on combining fields, but I could find anything to help me out with my specific problem. I have 4 fields: [FirstName], [LastName], [MidInitial], & [Salutation]. I need to combined these into 1 field for a report so it shows. ex: Doe, John, J...

How do I replace Reference "MS 10.0 Object Library" with "MS 9.0 Object Library"? I need to do this for my code to work. Any help would be appreciate. Thank you, Full Williams

Hi there, I have a problem with my database when I copy it onto another computer. In the database that's on my computer (Access 2000, Windows2000 Professional) I have some code that adds a list from one List box to another: Member's --->> Inivited Members. When I copy the database onto...

Hi, I'm doing the same function in 2 databases. The first database I created I used DAO. The second one I thought I would try using ADO. For some reason the database is running much slower with the ADO. Basically what I'm doing is adding Members to a Meeting. I have 2 list boxes one on...

Hi, I have a form that has controls in the header and detail. Is there a way that I can combine their tab orders so they are not separate? Right now I can only tab in the Header. If I set the focus on current to the first tab in the detail I am not able to tab up to the header. Any help...