Search results

Hi All I have a table which contains a scope of works for some job we are doing. The data is entered in the format similar to: 1: Open the door 2: Walk through the door 3: Close the door I am processing this through VBA and adding other variables in such as quoted amount, and variations...

Hi All Its been a while since I have played with Access, but I need to do an upgrade to a program I wrote to help me work. The upgrade is to instigate a standard order. So for example one of the products we make is a control board. This consists of 30 odd items that we order from three...

I have a need in an application I have been working on to grab an attachment from Outlook and file it using access to identify the file name adn location. Has anyone played with this idea before? The issue is that suppliers send me large amounts of pdf data on their products, I am trying to...

Lets say ytou have a number of interdependant recordsets in module called MyModule. An error occurs. Using other methods you can return the module name MyModule. Whta you really want to know is where in the module the error occured, so you can focus on the offending recordset. The error may...

Why not? This seems to be a prefered solution where you have numerous recordsets each dependant on the last?

I am reworking my error handler to better help me identify the error location. According to a couple of books I own you can add line numebrs to your procedures and modify your error handler to return the line number. They then go on to say that this is well documented on the web and that you...

I have a form with a combo box to look up suburbs. To speed up form loading we limit the suburb by state intially to limit the length of list. The problem is that when the user wants to enter a different suburb from another state, how do we requery the combo box and move on with the new data...

The following is a query string I want to build in code (I think) to return specific records at runtime. I have knocked up a sample to get it to work first in the query window, however, every time I try and run it the query is telling me I need the keyword Exists. I have looked at my books and...

I think you could add a field like Iif([CompanyName]="Company Name I dont Want","",[CompanyName]) This would replace the company name I didn't want with an empty string. HTH

SQl and ADO and Order and ??????? I have been making a wizard for setting parameters order of appearance in my application. The table structure is as follows: tblPool PoolID Type Construction Sanitiser pH Control trelPool RelPoolID PoolID TestID tblTreatOrder RelPoolID Parameter TestTreat...

Remembered- found an example I still had. Me.Parent.mobjWiz

Still giving variable undefined in subform:mad:

I did this once before and got it working, but lost the example I had in a harddrive incident. I am setting up a fairly complex wizard using form, subform model. The forms and subforms are unbound, and I intended to dump the data into a class to process on completion of the wizard. I am...

Access should have a built in shortened documenter for table structures. Anyway that is beside the point. I am working on a design for a new application. It is for testing water for swimming pools. The following are the documented requirements: -Any pool requires a test -Any test can consist...

Apparently not, which is why I am looking at this code.

According to Microsoft the functions dps_OkNew should allow my code to update the underlying table even though the user has no direct permissions on this table. However, everytime I tun this code it prompts me with a warning that I do not have update permissions blah blah. Function...

Thanks for your help again. I just really needed a hand on the approach. I am not sure I want to go this way at all, certainly in the short term. The instrument is designed to work with a computer. Originally the manufacturer intended to return data to Excel (although I only found this out...

Her we go then. Most of the time the instrument will output 5 lines in final configuration. In the current mode it spits out 7 lines. For most tests. For some tests it spits out 8 lines, 9 lines and may even go to 10 lines. In the case of these tests we are only interested in one parameter...

I don't use filters prefering SQL instead, however, I think your approach is flawed. To filter move through your list box first, finding all selected regions and add them to a string. Use this string as your filter source and I imagine you will be fine.

I haven't used transactions yet. However, I can comment based on experience in other areas. You must commit your append first. Even though you have committed your append most probably the DSum will still not include your most recent addition. I had to use movelast to retrieve the value just...