Search results

Hey guys, I need assistance writing a query in MS ACCESS. I have a table called PrePaidCards that holds my basic data about the cards. When a card is sold the basic information is entered into the PrePaidCard table (Date sold, amount purchased, etc…) along with a field named Empty. Empty...

I think I have it worked out. Thanks for your help! James PS I gave you “thumbs up”!

I am not sure of anything. This project was the first I have done with the upsizing to SQL. But it looks like you are correct. When I double click them the ones that have the SSM$ seem to only have the original data that was there when I upsized the tables. The tables with the globe show...

I have two sets of tables. 1 - has SSMA$ before the table name 2 - has an arrow and looks like a globe next to the table name Do you think I should copy all of the tables or set 1, or set 2? Thanks for your help by the way. James

Hey Guys, I have an Access DB that I upsized the tables to SQL 5 backend. Since then I changed laptops and by back up (original) files were lost. I have the front end that is talking with the SQL tables fine but I need to make start making some enhancements and don’t have my original DB...

DUH... I guess I had a blond moment. I should have thought of that! Thanks Guy49! James

I just upgraded from Excel 2003 to Excel 2007 and have come across this issue. I am entering a 17 digit number (i.e. 12345678912345678) and Excel changes any numbers over Fifteen to 0s (i.e. 12345678912345600). The cell format is Number with 0 decimal places. Any suggestions would be most...

Ah, thanks Bob! James

Thanks for the information Bob. This is the first (and LAST) time I did this! I have a couple more fields that I need to enforce integrity on. How would you suggest I do that now that the tables have been upsized?

I have a MS Access front end with a SQL 2005 back end. We just started using the database and needed to make a change in one of the records. The Primary key for the Cash_Record table (the parent table) is a check control number (CR_CCN) and the data was keyed in wrong. There is a sub record...

Great idea Richard. Thanks! James

Because the form doesn't requery and I have tried Forms!form1.Refresh and get nothing. It's ok though. I sent the database on as it was. I just wish I could have made it a little cleaner or functional with the requery to refresh. Dave I want to thank you for all your assistance with these...

Does anyone know the Syntax to requery form1 On Close of form2? I put in the On Close of Form2 : Forms!form1.Requery But that didn’t work. Any suggestions? As always thanks for any ideas to suggestions. James

Is there a way to see the Next Record_ID (AutoNumber) if there are no records in the table? I have a form that doesn’t submit until the user clicks a submit button. One control in the form requires a combined value of the date and the Record_ID and I need a record to start the process...

Hey Paul, Nevermind, I got it worked out. Thanks again for all your help. James

Hey Paul, By chance do you have a few moments to look at another piece of code that was in that piece you looked at earlier? This piece was a few lines below what you helped me with. If not I can always post to the group. James

Hi Paul, I used the Nz function and it helped me to figure out what I was doing. I have to hand my head in shame on this one. I had the wrong date format. I have been using m/d/yyyy and in the code I had a typo of d/m/yyyy. Shame,. Shame on me! I been coding for 15 hours but I am still...

Hey guys, I am getting an error, “Invalid use of Null” in the chkSum line. I get MsgBox "After SQL 1 Runs" then the error. I do not get the second MsgBox "After chkSum"! I checked the IPP_Tracking table and neither the Calc_Pmt_Amount field nor the Date_Batched field has a Null record, at...

That's what I thought. Thanks for your help. James

Hi Paul, Thanks for helping out. Will DLookup Sum the totals? James