Search results

Hi all, long time no see from me as my job changed a bit, and I'm not doing anything near the amount of VBA I used to do. So apologies, but I am just a bit rusty and would appreciate a hand. I need to split a field that is consistently delimited by commas, and contains numeric strings between...

Hi folks, I run a membership database for a local society that holds a small private membership of 400 or so with around 80 institutional subscribers, and holds subscription information, payments made, subs owing, publications despatched, gift aid claims, general notes, orders and invoices etc...

Hi folks. I am trying to make a link between an Access form, and an Excel spreadsheet so that a user can open the spreadsheet with a button click, and initiate the Excel 'Find' function to take them to the cell containing a string lifted from form control. I need the search to run across sheets...

Dear all, I am using the below, on a click event to link images to records, and the code works fine. Private Sub Command5_Click() Dim f As Object Dim strFile As String Dim strFolder As String Dim strFolderlo As String Dim varItem As Variant Set f =...

Hi folks, I work in an organisation where I have developed dozens of Access databases over the last 18 years or so most of which remain in operation and many are core to our daily operation. The time has come to really push to move the back ends from the standard network storage on which they...

Hi folks. I run a membership database where I use a bunch of nested queries to show who has paid/not paid their subs in a given year, and also who has overpaid and underpaid. I then set my membership forms recordsource to be the result of these queries. This is good for filtering the data, but...

Hi folks. I have three backends with multiple front ends which have all been playing nicely with each other for well over 10 years now and regularly have 40 users over a network. Relationships are set in each back end and the structure has been fine. However a change in a table structure and...

Hi folks it's been a while since I last visited but I've not been doing much DB development in the past few years. I've recently helped a PhD student by redesigning an access database setup for recording different types of artefacts. The database consisted of a central table holding artefact...

Hi folks, the following sql works OK for me as part of a larger SQL statement, but I would like to more efficiently reference the Job_Nos from a table in which these particular job_nos are listed. What would my statement be, to select the Job_nos in the IIf, from a table...

Hello folks. I am using a little explanation posted by Allen Browne (here http://allenbrowne.com/casu-13.html on expressing minutes as hours and minutes, and I have written this little function: Function Calc_HrsMins(TotalMinutes As Variant) As Variant On Error GoTo calc_hrsmins_error Dim...

I am using a utility put up on line here : http://www.peterssoftware.com/mlm.htm to represent spatial data using Googlemaps from within an Access database. I am using the mapping function with app. 2000 pieces of project data, that has OSGB coordinates, that are converted on the fly to lat lng...

I have a form where Conditional Formatting has been used. I want to run a routine to show me on which Controls the Conditional Formatting has been used, and what expressions were used in the Formatting. Having Run Database Documenter, I was hoping to identify all the Conditional Formatting used...

Hi all, I have some SQL code I wrote last year that helps us transfer data from Excel timesheet spreadsheets into a backend access database. Recently the code has started to stop working, but quite erratically (i.e. for one user the code fails to run, but for another it will, despite Permissions...

I have put this code together to delete linked tables if they exist, so that tables from a different back-end can be linked in, as required. I know my understanding of error handling is poor. Would anyone please have a look at what i have written and comment on where I need to improve? If the...

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)...

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...

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...

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...

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...

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...