Search results for query: *

Good Day All, I use Access as a font-end only and linked SQL 2K tables as my back-end DB. My problem is that when the application starts up, this connection (maintained by Access) states that it does not have the username/password in the connectionString or a trusted connection to my SQL DB. I...

Good Day All, I have consulted the FAQ's but could not find what I was looking for - maybe you can help. This must be extremely simple, however, I can not access what I need! I would like to know what the recordcount is for a subform. Basically I want to know if there are any records at all -...

Good Day All, I would like to trap Access Errors which originated from a databasis query. I.e. Duplicate Primary Key etc - to give a better error message to the end user. I have figured out that I can use the Error Event for this, but that means that I will need a list of possible error...

Good Day All, I have two questions. I want to check for any open Forms related to my application when the application exits, and close any if they are open. What is the best way to do this? Secondly, I am doing quite extensive error handling of my own, but I would like to intercept standard...

Hello All, I need to run an 'update stock balance' stored procedure when a user deletes an invoice item. For some strange reason the following events all fire BEFORE the actual delete takes place in the DB, namely: BeforeDelConfirm AfterDelConfirm Delete I need to know when the actual delete...

Good Day All, What I want to do is very simple, but clearly I am a bit dim :-). I have a view only form - which selects a load of transactions into itself - and I have set this form to be a continuous form (which I never really worked with before). What I am after is to make a change to the...

Dear All, I am delving into dynamic stored procedures. I think what I want to do is pretty straight forward. I have 5 possible paramters of which only 2 will always be present (dates). So, for example: @anIDColumn int @toDate datetime @fromDate datetime @anInvoiceID int @BinID char(12) I...

Hello All, I would like my SQL statement to do the following: ... where (@givenID = 0 or (@givenID<>0 and myColumn = @givenID) That means that if my user selected "All", it must not concern itself with the value for myColumn, otherwise, it must set myColumn = to the ID selected by the user. I...

Hello All, I think this is a simple question. I have set up a combobox to dropdown values for selection from a base table. So, for example, if you have to choose marital status, it will dropdown all the values in the marital status table. However, I would like to know how/if I can add "All"...

A While ago I posted a question regarding advice on how to do quite a few calculations on the DB side as a transaction, and have thus stumbled into the world of Transact-SQL. The following script works in the query analyser and does exactly what I want it to do, however, I would appreciate it...

Good Day, I have used Stored procedures for all of my SQL requirements from code (new language plus new at stored procs for SQL. So please be patient!) I would like to now build on this layer of knowledge by building in transaction processing on the DB side, or on the coding side if not...

Good Day All, I have a button on a subreport which brings up another (neccessary) form(A) - when this form(A) closes, I would like the subreport to requery/refresh, however, I can not find a single event which fires after my form(A) closes! I can not put the refresh code under the button after...

Hello All, I think what I want to do is fairly simple, its just that I haven't used the Outlook Object model before. If I have a message template - is there a way of writing some script to the Open event of this message which will populate the &quot;To&quot; field with the email address...

Hello All, I am finally getting somewhere with my reports, however, I do have another problem (small I think). I am reporting off a transactions table and are displaying the results. I have a table called CurrVatPerc which holds the current VAT(tax) percentage applied to goods. I would like...

Hello All, Is there a good way of allowing users to input paramters to a report? I would like my user to select a Stock Item up front, the report will then give a load of details about this item, including recent transactions. How is it done? Any help would be appreciated! Regards, EvE

Hi All, Simple question I think. All I am doing is selecting all entries of a table for display on a report - in my footer I would like something like There are currently xxx entries. Now, in my xxx textbox (is this the right way to do it??!), I have as my recordsource: =Count(*) Which yields...

I have a stock transaction table. I want a form which: inserts new records to the transaction table only display and allow edits on records added today. So, in theory, I only want to display transaction records equal or greater to today, but still let Access handle the...

Can anyone tell me what I am doing wrong here? I have a Command with two parameters set with values: Parameter1: .Name = &quot;@testInput1&quot; .Type = adInteger .Direction = adParamInput .Value = 1 and Parameter2: .Name = &quot;@testOutput2&quot; .Type =...

Hello, I need to call quite a few stored procedures. Had a look at a few examples re passing parameters etc. and everyone seems to keep recreating connection, command and parameter objects when calling these proc's. Is there a reason why I can not write a generic runProcedure function for this...

Good Day, I am running in circles here. What are the most common way to deal with Access ADP forms when it comes to Insert/Update screens? I have complex and obviously less complex (like Stock Maintenance) screens to consider. Should I let Access handle the traversing, inserting of new and...