Search results

Thanks. I guess the gist of my question is how to fire the function now that the form is no longer the data entry point. Do I try to run it when I enter the data remotely (using SQL/VBA) or do I run it an an event of the form (eg Oncurrent). I think logically it should run when the data is...

Thanks for reply. I understand your point. The parameters behind NI and pension change. The data therefore needs to be calculated at time of input, and stored.

Not sure of the best place to pose this question, as it can be approached a few different ways, but I've not found a good one yet. I have a form in which job times for individuals is entered. As the data is entered, a macro fires to calculate various costs (Nat Ins/Pension/Total cost etc etc)...

Thanks for replying to my post. I understand the problems you raise, and can envisage implemented a system as you suggest. As this database if effectively a shadow (i.e it is not governing who gets paid what), I think this is appropriate. Today I have implemented the spreadsheet, and have...

Have used a technique to insert records into an Access database from an Excel spreadsheet, using Insert SQL. I need to get verification that records have been appended, but understand that Insert SQL does not support this. Can I use DAO in the same function? The Access database is referenced...

thanks very much - this has given me some good ideas to work with and has improved my understanding

Thanks for your reply. Can I ask you to be more precise so I can understand better? I understand and use this method for controlling control values from queries although I have never used non loaded forms. For loaded forms the value is used. How is a current value established for a non loaded...

Thanks for reply - I think you understand what I am after. The user opens the database and on menu picks a group of records to work on from a combo. This sets "FullAccession" When in that session records are subsequently created in various tables (including eg tblGroups) I want the value...

Can anyone explain to me how I might use a value selected by a user on a database opening menu (which remains open), as a default value for records created programmatically in other tables? I wonder if I need to write a function to repeat the value - but I cannot see how to use a form value...

although is not the same as If Me.ActiveControl <= limit0txt Then Me.Bone = 0 If Me.ActiveControl >= limit1txt And Me.ActiveControl < limit2txt Then Me.Bone = 1 If Me.ActiveControl >= limit2txt And Me.ActiveControl < limit3txt Then Me.Bone = 2 If Me.ActiveControl >= limit3txt Then Me.Bone = 3...

Thanks - active control is working fine - the relevant control has the focus and has just been edited to trigger the update. Now that code is very tidy thanks - I will give it go. Yes I have a table with a single row of values as assumed. thanks again MAtt

Thankyou for your reply. 1, My conventions - yes I see I am sloppy - I guess I am using 'txt to differentiate the variable from the datasource 2, re: Where/how would I assign the variable - what would this look like with the refernece to my form control? 3, Can I use DLookup values in the...

How to use value from form as Global/public variable I want to use several values entered in form controls as variables within multiple subs triggered by further form edits. I do not want to define the variables in each sub as this will bloat my code, but I am not being successful in declaring...

Think I have found my answer. I read the pages here:http://allenbrowne.com/ser-23a.html and applied some of the code to my functions and it is running as I require now. Matt

..and no, I haven't tested the variables as singles.....I copied the definitions from the Excel VBA where they were defined. How to do I test? thanks

Thanks for your reply. Here are my constants as declared in a module: Option Compare Database Public Const Pi As Double = 3.14159265358979 Public Const A As Single = 6377563.396 Public Const B As Single = 6356256.91 Public Const e0 As Single = 400000 Public Const f0 As Single = 0.9996012717...

Hi people - I am really a clumsy novice with this, especially in dealing with errors, so forgive my ignorance. I have a form which calls some VBA functions I have found and put together in an Access module, that pass a location textstring to the Google API service and return latitude and...

Thanks for replies, and apols if I am not clear enough. I have Jobnos which identify a piece of work by my organisation with its location and budget. All staff time is recorded below this Jobno. I have Reportnos which identify and index reports written by my organisation. The report...

Hi folks. I need to redesign a database to include more complex relationships between 3 variables non of which are mutually exclusive. These are my 3 tables/fields. Each field is unique in its table. T_Project.JobNo T_Accession.AccessionNo T_Reports.ReportNo There is no clear relationship...

So I have a query that in a very unperfect way produces a result that for say 90% of my data will be satisfactory. I now need to take the results of this query, and search for any given context, and then output that value into a text box with whichever column name the value was found in (ie...