simulationguy
Last Activity: Jul 28 '12, 09:46 PM
Joined: Feb 5 '10
Location:
-
Thanks the secret was that I had to have everyone get permissions for the shared email account. The MS Access database then sends the outlook appointments out for any of the users but all the replies go back to the shared mailbox. It worked fine after I got the permissions changed. Thanks! -
How to Change the Sender account or reply to in outlook
I have some vba code to create an outlook appointment and send it to users in a list, but I would like to change the sender account or the email address that gets the reply when the appointments are accepted or rejected.
Basically a PM may send out the request but instead of getting 100 responses back we would like the responses to go to another email address (shared account). I think there is a way to change
Getting... -
MS Access goes into read only mode
Has anyone encountered this, I uploaded an access database front end and back end on a client server and nothing was editable I opened the backend and all of the tables were non editable it was like read only mode. file properties didnt show read only. I could rename it open it and it would work fine. change the name back and read only again. I can do a work around by adding a subdirectory and copying the files into it but I am concerned the problem... -
Thanks, I tried adding .movefirst after the requery but it gave me an error, Run-time error '2465' Application-defined or object defined error.
The strSQL statements get initialized just befort the with loop, I just didn't show them to make the code shorter. What I don't get is it all works with 2003.
I just want to go to the first record in the set
Any help would be greatly appreciated
...Code:strSQL1
Leave a comment:
-
Error When Converting to Access 2007 Record Not Available
I inherited an Access 2003 database runs fine in 2003 but in 2007 I get an error on updating a form. Record Not available on the last statement
!ItemNumber.Set Focus
Does anyone know why Access 2007 is different and any clues on how to get it to work?
...Code:With Forms!frmMain!frmSKUInput.Form !WhichSKUCombo.Value = "" !WhichSKUList.Value = "" .RecordSource -
Crap! Not quite there, the code runs the saved export okay the problem is that the saved export also contains the path name which will not be the same when I give the database to the end user.
and the textexpport method doesn't write the file out correctly and if I use the specification there is a bug in 2007 (from what I found) that makes it so it can't find the specification even when its been created correctly.Leave a comment:
-
Thanks! I am using Access 2007 and that was exactly what I was looking for and it worked.Leave a comment:
-
its not a saved querry its a saved export. So after I ran the querry I went to the export data menu and set up the way I wanted to export it to a text file directory file name etc and saved that.
I can go to the export data menu and select the saved export from the list and hit the run button and it recreates it just what I want, but I want to execute that in code.Leave a comment:
-
How can I run a saved Export in VBA ?
I have several saved exports (querries to text files) and I would like to have a button to execute them in vba and write out all of my data files. Anyone know the syntax for that? -
Thanks I think I will reorganize it with tabs I didn't think about that at first because its one of those that started out with just a few fields and they keep adding to it incrementallyLeave a comment:
-
Thanks but I discovered the issue, it was a single form
and I had all of the fields in the header section instead of the detail section so I took a hack at it and moved all the fields to the detail section and the scroll bars work like they are supposed too.Leave a comment:
-
Vertical scroll bars don't work in Access 2007
Any of you run into this, i have tried setting the properties of the form to vertical scroll bars only and both neither seems to work. The horizontal scroll bar works fine but its a long form and I cant scroll or page down or anything to get to all of the fields.
Works fine in design mode but not form view -
Error 2105 with Access 2007 -
I have a database the runs fine in Access 2003 but this routine crashes with error 2105 "You can't go to the specified record" in Access 2007 on the last line !itemNumber.Set Focus
Any idea why its different in 2007 or if there is a work around? I tried moving the .SetFocus line out of the With statement but same result.
...Code:With Forms!frmMain!frmSKUInput.Form !WhichSKUCombo.Value = "" -
Grouping in a Query? Kind of an Odd Sort Problem
I have a table with names and a linked table with start and end dates for activities
They want a report (which I am exporting to excel) listed by the earliest end date for an activity. I can create a query that lists names alphabetical and then all of the activities for that person by earliest end date. But they also want the list not in alphabetical order but in order of the earliest end date of all activies for that person.
... -
Thanks! I was trying to do it through the reports open event and getting nowhereLeave a comment:
-
Print Single record vs whole report
I have a report that prints all of the records out from a table, usually executed from a reports menu. The user also wants a print button on the data entry form that will print out the exact same report but only for that record. Is there trick so I can use the report but limit it to printing out the single record? -
Here is a link to a page that describes the approach for a multirecord form if you ever need it. Its a hack but it seems to work
http://www.blueclaw-db.com/download/..._combo_box.htm...Leave a comment:
-
Crap, it didn't quite work as expected. The combo box works great but the problem is when it filters the records in the combo box then it also makes the selection in the other records go blank. I think its close just missing some little trick.Leave a comment:
-
Thanks! That is exactly what I am trying to doLeave a comment:
-
I appreciate any help. Hopefully I can explain it okay.
There are two combo boxes (two fields in the same record) , one table. One field in the table is a location and the combo box lets you select that location from another table. The second field is an area and the combo box lets you select the area from another table. But based on the selection of the Location, I want to
limit what areas you can pick. The table...Leave a comment:
No activity results to display
Leave a comment: