Search results

I've been searching these forums but couldn't find what I'm looking for. Here's what I need - maybe I'm going about it the wrong way. I have a table called Customers. For each customer (custid) there can be multiple contacts - contact1, contact2, etc. each with their own phone, e-mail, etc. I...

I have a text field called Notes - where we will add notes about the particular job. What I want to do is have it a locked field with a button 'Add Notes'. When clicked it will insert the date and the user name of the person and then let them type the notes. When they move to the next record - I...

We are using an Access front end and connecting via OBDC to SQL Server 2000. My question is this - currently all of our queries are in Access and hitting the SQL database for data. Should I be using stored procedures via SQL Server or keep doing what we're doing? It seems like we are moving...

We have moved our database from Access to a SQL back-end still using an Access front-end. For the most part everything has went really well. I have some code that checks to see if a serial number is in the system when it's entered on the New Jobs screen. In our old Access database it searched...

I have a field (AR#) that has an "on change" event. This is supposed to check through the database and see if that number has been here before (it's like a job # / serial #). It had always worked fine - now suddenly this field, and this field only, reacts VERY, VERY slowly when you type a number...

I have a form that is based on a query that has all of the sudden become non-updateable. After searching this site for a while - I found someone who had a similar problem, it was reccomended to check the query the form is based on to see if it could be updated. I did that with mine and the query...

As the title says - I am getting a Return without GoSub error for every button on a particular form. Nothing has changed (that I'm aware of anyway) and now it is happening. The only possible thought I had is I have one user using 2003 and all others using 2000 - could that have anything to do...

I have tried to search previous posts for my solution but have been unsuccessful. In a query I have date field (datequoted) that I use in a formula (currentweek) to see how many weeks an order has been quoted for. This is what I currently have: DateDiff("y",

I have a custom function for a sliding scale markup on parts. If I make it As Currency I get an #error if PARTS is null or 0. If I make it As Variant, I can't get it to show as currency. Here's the function: Public Function partsmarkup(parts As Variant) As Variant If IsNull(parts) Then...

I've been searching all the forums and unable to find my answer. What I want to do is show on a form the average quote for the specific model number. On the form there is customer info, product info, etc. I want to see the average of what we have quoted every other time we have seen this...

I have a field called Shipdate. I have created a new field that is called invoicedate. What I want to do is copy all of the shipdates and paste them in the invoicedate field for my old records. From here on out they would be distinct fields but for old records and reporting purposes I need those...

I have an event procedure that enters the date shipped and closes a job out when the tracking number is scanned in our system. How can I make this so it won't overwrite the date shipped (SHIPDATE) if there is already somethng entered? And/Or how do I change this so it will only be when the...

I have a form that has two command buttons in order to view (and subsequently print) two reports. I have made some changes to database on my new computer - not to these forms though and I can use the buttons but my co-workers can't. The database was created with Access 2000 and we are all using...

I have downloaded the zip file by Pat Hartman with useful date functions (thanks Pat!) My question is; how can I use one of those modules in a query in my database? I have a Datediff field that only returns the actual number of days - after seeing the "Calculate Business Days" module from Pat I...

I have a query that has date parameters, so I see the info I need for the set time period. Once the query is open (in datasheet view) I am prompted to enter the time period every time I want to sort any field (i.e job number, quoted price, etc). Is that normal or is there a way around that? I...

I have a report that is generated by my tech's entering info in a form. What I want is for the date to be automatically entered the day that form is completed and then stored that way. Currently, the report is just set up with the =Date() function, so I get the current date everytime I re-print...

Hello, I am trying to "touch up" a database that I did not create, and I am sitll a beginner at Access. I have a combo box on a form, the control source is: SELECT [ProblemFound].[ProblemFound] FROM ProblemFound; How can I get this to sort in ascending order? The table it is derived from...

I think there is a simple answer for this, but I can't seem to get it. How do I set a combo box so the user must select something from it and not be able to add anything? If I lock the field - it doesn't let me even select one of the options. Thanks for your help

I have a field called "Date Quoted" in a query. What I would like to do is based upon the date in that field; have another field entitled "Status" automatically fill-in with an expression (i.e. Week 1). Basically; based on how old the quote it I want it to be called Week 1, Week 2, etc. If the...