Search results

this may not be the best way to do what i want to achieve but i'll detail it out here and we'll see where we go. I have a process that generates a CSV from a query but there is a need to override the default behaviour of a calculation within the query on occasion. the table has 3 fields which...

Hi All I am logging changes to tables by copying updates to log table and have hit an issue with a memo/long text field in that when it is used as a parameter to a query built using VBA if the field it is copying from is more than 255 characters it throws an error. I believe this is a bug with...

Hi All I have a form that is currently linked to the main form as a pop up form but the users would like to move it from a pop up into the form it pops up from. So i have created a subform version of the pop up and added it to the main form. All good ...... but...... When the pop up form...

Hi All I have a situation where I need to consolidate parent/child records into 1 line for a view of the data. The data looks like this: Consignment ID Delivery ID CMR SalesOrder 1234 1 Yes Yes 1234 2 No Yes 2345...

Hi All I have a multi select list box populate with a list of supplier that initially was quite a short list. This meant selecting all the supplier was easy. Now we have been using the system for a while the list box contents has grown and i decided to add a button to the form to select all the...

Hi All I am building an insert query from fields on a form and everything was working ok until a user added an apostrophe in a free text field which caused the query to not build correctly. So something like this: db.Execute "INSERT INTO [TABLE] (freeTextField) VALUES ('" & Me.freeTextField &...

Wondering if there is ANY difference in the way in which the following different versions of the same code are executed. Dim db as database set db = CurrentDb db.Execute "UPDATE [FACT-DeliveryInvoicesAndCNs] SET " & trimSelection("," & SQL) & " WHERE [FACT-DeliveryInvoicesAndCNs].id...

Hi All as is always the way, i'm going back through the early vba code i wrote creating my database and applying the knowledge and experience i have gained since writing said bit of code. I have been converting a lot of: Get recordset loop through recordset 1 record at a time if record...

Hi All I have a FE/BE setup and during normal working hours everything is running smoothly. There has been a question raised as to whether there is a way to see some data without the need to run up the access front end via sharepoint. Currently i have a couple of sharepoint lists which i have...

Hi All I thought i'd hit an issue with the latest update whereby i get the following error: But i have tried the following: Multiple database files Different folders on my local machine Confirming that the folders being used are in my trusted locations configuration Reverted to earlier...

Hi All On a number of my forms there are header and footer sections which are set to a specific colour but I wanted to make it a little more user configurable by allowing a user to select a colour theme/scheme that will apply to all headers and footers. I already do a couple of things as a...

Hi All So i am trying to generate a complex excel sheet from data from my database. I have currently 4 complex queries (but the need for at least 2 more) some of which use the results of 1 to generate total lines for the sheet. Also as part of some of the queries i am doing currency...

Hi All I have the following fields in my query calculating various values but in the end i need to know the Percentage of Waste value. This is working ok but i would like to sort based on the WastePercent field grouping anything 5% or less together, anything between 5% and 10% together and then...

Hi All I have a shared folder with the backend of a split database and users access it via a front end local to their machines. If no one has their front end open i can open the front end on my local machine accessing the backend via the shared folder on my local machine. If someone else...

Hi All I am creating a report that shows a limited selection of records and the details section is now pretty much set but i need to add a little bit of summary information in the report header as follows: I want to gather the first and last dates from the listed records and show a to and...

Hi All I have sets of records that all have a reference number and a status that i would like to query as follows: For example: This would show 1 line for M00158 with a consolidated status of No as not all the records statuses are Yes This would show 1 line for HLBU9503742 with a...

Hi All As an example I have 2 master records with 6 and 2 child records respectively selected from a recordset and want to get the counts of master and child into a dictionary to use in calculations later: Set rs = Form.Recordset.Clone With rs .MoveFirst Do While Not...

Hi All I have the following form: So far i have the form query supplying the columns of data up to the "Selected Currency" section. The 3 fields on the end (Currency indicator, estimated and actual amounts) are calculated based on the Currency selected on the drop down (it defaults to Euros...

Hi All i hope this one is a simple one I have a form that the user enters some information into and then a button to look up latest price for the input they have given and populate that on the form as well. My price table looks like this: Price Table Customer Arrival Date...

Hi All trying to figure something out wondering if anyone had any pointers/ideas on best way to achieve the following? I have some temperature data for dynamic period, as in can be any number of days, that i'd like to assign colours to based on relationship to min and max temperature. I have...