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

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

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

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

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

Hey guys, Is there an easy way to put a field in a report that DSum a field from another table than the Report’s Source? Something like Customer_ID (from Customer table) Customer Info (from Customer table) Total purchases (from the Sales table) Would the Source of the field be something...

Good morning guys, (I thought I posted this already but I can’t find where I put it so I apologize if you have seen it already here today) I am getting an “Application-defined or object-defined error” when running the section of code below. I have never seen this error and don’t know how to...

Is there a way to launch specific forms at login (or after the Splash) depending on user permissions or rights? I am using MS Access 2003. Thanks in advance for any assistance. James

Does anyone have experience Upsizing that could give me a couple pointers? I just Upsized a MS Access 2003 database into SQL Server 5 test/dev environment and have run into a couple of snags. I am thinking I did something horribly wrong during the process but I don't know enough about the...

I need to find a way to create a dynamic 3 column combo box (1 will be week number, 2 & 3 will be date range from/to) It should be able to start on a specific date and end with current week. I have a week number combo built (See below) but I don’t know if it will work after the new year. And...

Hey Guys, Is there any way that I can turn off the record update notification that pops up when I run “DoCmd.RunSQL”? There will be just too many of them once the users start updating files all day. James

Hey Guys, I have an update query that goes through the motions like it is updating a table but the value just isn't getting the value into the table field. It see the correct number of records so the WHERE clause seems to be working, just no value in the field. Can someone take a look see...

Hey Guys, I have a Radio button control (Option control) that will only give me a 1 or 0, I know…. This is normal but because of a manager’s request for simplicity when she hand writes some queries, I need the values of Yes and No to be stored in the table’s field. I know I have got to be...

Can someone take a look see at what I am doing wrong with using DCount with IsNull? I got a table that has a field called New_Requests and I need a count of all records where New_Requests is Null. I would have thought this would have been very simple, but apparently it’s not as straight...

Hey Guys, I have created a dynamic report and want to set the header in my VB that sends the report criteria. This way I can use the same report but send different criteria with the proper header. Is there a way to do that? James

Hey Guys, I have a control that has a formatting defined in a "Sub Form_Current" (See code below). If IsNull the BackColor is vbGreen if not vbRed. The Form has a control button that when clicked will check to see if the value IsNull, if True the control will be given a date, False the...

Hey Guys, Is there a need to clear the value of a variable somewhere? Once you declare the variable and give it a value in a form module (especially one that is a new data form) should I be giving the variable a Null value somewhere else after it has been used? James

Hey Guys, I hit another coding speed bump and just when I was going at a fair speed too. I don’t know if this belongs in the Reports Forum or the Form Forum so I will apologize if I have miss-posted. I got a new record form where the user needs to be able to review specific pieces of...