Search results

  1. I

    Change Variables in Query using VBA

    Hi, I have a report that has an underlying passthrough query. I would like to be able to use a form to input the date and then pass the date entered into the form to the query and then run the query. I have seen this done before but unfortunately I didn't take notes. Can someone help...
  2. I

    Update Null to Zero value

    Hi datAdrenaline, That is awesome. Thanks so much for your help on this one. May have taken a while to get there but will save a lot of time in other situations now that I understand what is happening. Thanks for everyone's help on this also, Cheers Ian
  3. I

    Update Null to Zero value

    Thanks DatAdrenaline, I like this idea. Will this approach only update those fields in the record that are null. I have shortened the query for illustration purposes but can't seem to get it to work. I get syntax errors. Can you enlighten me as to what I am doing wrong? Thanks Ian
  4. I

    Update Null to Zero value

    Thanks, Access seems to have a habit of automatically inserting double quotes around the Is Null. Once I manually removed each quote it worked, Thank you so much. Saved me a lot of time. Ian
  5. I

    Update Null to Zero value

    Thanks, I think both will work. However, I am getting an issue with the datatypes. In my destination field the field are number fields with Field Size "Double" and Format "Standard" I am using 0 for the "Update to" value and where the criteria "IsNull" Also tried putting 0.00 as the...
  6. I

    Update Null to Zero value

    Hi, I am in the process of building a database in Access 2003. I am trying to update a table to replace all of the Null values in number formatted fields with zero. I thought about updating one column at a time but that does not seem to be efficient. Does anyone know of a way to do all...
  7. I

    Concatenate a list into one field

    Hi, I have a list of services that pertain to a client ID. One record for each service with a date the service was performed. Does anyone know of a piece of VBA code that will concatenate all of the service dates for each client, create a new table and list the result by Client ID based on...
  8. I

    Concatenate a list into one field

    Hi, I have a list of services that pertain to a client ID. One record for each service with a date the service was performed. Does anyone know of a piece of VBA code that will concatenate all of the service dates for each client, create a new table and list the result by Client ID based on a...
  9. I

    How do I insert an underscore between two alpha characters using VBA.

    Thanks Chris, That helps. You have saved me a boat load of time now and every month after that. Cheers Ian
  10. I

    Data Loading help using VBA

    Hi, I am trying to upload information into a Lawson Database. The Form has a function but I am having trouble fuguring out which control ID it is. The regular upload interface add-in doesn't support the Load button. Can anyone tell me which part of this code refers to a button control? I...
  11. I

    How do I insert an underscore between two alpha characters using VBA.

    Hi Chris, That is pretty awesome. I have put this in a module in my database. How would I apply this to each row of my database table? The table is called Test1. I am running Access 2003 Thanks Ian
  12. I

    How do I insert an underscore between two alpha characters using VBA.

    Thanks Chris, I'll gave it a whirl. Cheesr Ian
  13. I

    How do I insert an underscore between two alpha characters using VBA.

    From the left yes but from the right it can vary. However, there is always a date after the company name, if that's any help.
  14. I

    How do I insert an underscore between two alpha characters using VBA.

    Hi, Yes, unfortunately I only want to replace the spaces with the underscore where there is an Alpha space Alpha. Here is a sample of the data. The above data is all in one field. If I parse it the is split into three cells. The problem is that I have over 5,000 rows with varying words and...
  15. I

    How do I insert an underscore between two alpha characters using VBA.

    Hi, I have a file that has a field that contains both company name and numeric data. I have tried parsing the data in excel but the company name has multiple words with each word separated by a space. I cannot figure out how to replace the spaces between the company name words with an...
  16. I

    Hide Zero Values in a pivottable

    Hi I am trying to hide zero values in a pivottable in excel. I have tried the following code but can't seem to get it to work I have a row field of "Project_Number" and a column field of "Year" and a page item of "QTR". The value is "Sum of OPEN_PO_AMOUNT" I have some values that are...
  17. I

    Error handling code problem

    Thanks lagbolt, you are right on the money. Ian
  18. I

    Error handling code problem

    I am trying to get this code to work but I seem to have something missing and I can't figure it out. I am trying to check it in the immediate window of the Visual Basic Editor and I keep getting a compiling error. I use the TestError (5,0) as my test. Thanks Ian Sub TestError(intValue1...
  19. I

    How does a save button handle the record?

    I have a conceptual question that may help me understand what a save button actual does if written correctly. My thought is that when a record is retrieved from the database and displayed on a form , the fields are not bound to the database. When the save button is clicked it takes the...
  20. I

    Transpose data from form to table

    Hi Paul, Do you do this through a query or do you use VBA to do this? Ian
Back
Top Bottom