Search results

Hi, I am importing files that I want to move to another folder after the import is complete. I tried the MoveFile method and I get an error 70 for permission denied. I then tried the CopyFile method with the idea of deleting the file after the copy. The copy works but the delete doesn't and...

Update. I went ahead and related the two tables but without cascading deletes. My code then worked. Anyone know why? It seems to me that the code should work either way. Is this MS's subtle way of making developers relate tables. I know of many Access developers who never relate tables...

Thanks again Rich, I tried using the SQL1 and SQL2 and the result did not change. I also tried to look up "dbExecute" in Access help, but Access help could not find it. I couldn't find it in the object browser either. Is it one of those undocumented items? If so, how do I find it? Thanks...

Try the VBA Developers Handbook by Ken Getz. It's a Sybex book.

Thanks Rich, No, I have not set the cascade deletes. I thought of it and I may have to do that as a quick solution in this case. But I do not like to use cascade deletes because I think they are very risky. If I relate the tables, I will cascade updates but never deletes. But this would...

Hi, I am having a problem deleting records from a detail or line-item table. I have a PO table and a PO_Detail table. There are times when I must remove a PO from the tables and I am using the following code: Private Sub RemovePO(PO_No As String) 'Remove this PO from the tables...

The problem with MS's approach is that it really should be consistent with what people do under manual situations because that is what people will expect when the computer does the rounding for them. People always round up when a number has a .5. This is what MS should do too.

Try putting the SQL that the rst is based on into a string variable and using the name of that variable in place of "rst" in the DoCmd statement.

Thanks BigSlimSlade! I took another look at the form's design and found that the row source of the list box was not set until the list box becomes visible. This never happens if the form is loaded in hidden mode. So there was never any real items to select. As result, even though an item was...

Hi again, I am selecting items in a listbox on a hidden form and I know that they are in fact selected. But I go to read the values of the selected items, I get null. When I actually select items on the form when it is not hidden, the values of the selected items are not null. What else do I...

Thanks pdx_man. After reading your suggestion, I took another look at the code behind the command button. Then it hit me. The sub was private. That was why it didn't work. When I made it public, my code worked. Thanks again! Mike

Hi, I have an Access app that opens a form in hidden mode. I am able with code to get the values contained in the textboxes of the form. I am able to select items in a listbox on the hidden form. However, the hidden form contains a button that I want to "click" using VBA code. I am...

My security flag goes up too. That is another reason I am seeking advice. Do you know of an acceptable alternative? Using MS Access may be more secure than the current mini-terminal approach. For this project, I can use all the advice I can get.

What we want to do is click a button from an MS Access form and as a result settle a credit card payment for a sale. The user will have already entered the credit card number and expiration date along with the other info. When you use a credit card at a store, they run it through a little...

Hi, Has anyone used CyberCash from Access? My company wants to request credit card payments through the internet from Access. They have a web site that receives credit card payments now. Does anyone have advice on how to do this? Thanks, Mike

Do you mean that I can't use any aggregate functions if I reference a text box for criteria?

Hi, I'm trying to run a query where a date is between two dates that are contained in text boxes on a form. Access keeps telling me that the expression is too complex. I used a CDate function in the query but it doesn't change the results. Anyone know how I can handle date criteria in a...

Try using an aggragate function (Ave) in the footer of the subform and put a text box on the parent form that equals it. Say subform is frmITrans and the text box with the average is txtAve. On the main form the text box to show that average would equal frmTrans!txtAve.

Hi, There is another wrinkle to this issue. Sometimes the value list must show numbers from 1 to 15. However, because the field is text, I have added leading blanks to get them to sort correctly. That is 1, 2, 3, ..., 15 instead of 1, 10, 11, ..., 9. So the table containing the locations...

Hi, I came up with a solution to this problem though I don't like it. No matter what I did, I couldn't get the combo box to show the right list. So I changed the row source type to "List" and on the Enter event I run a cursor to fill the list with a concatenated string with a ";" following...