Search results

@Minty ok so that looks like it is going to do what i want, thank you that helps alot. always learning something new thank you for pointing me in (what i'm hoping is) the direction

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

@CJ_London thats a useful bit of code thank you

@The_Doc_Man thank you for the detailed explanation, as stated previously i am creating DB vars for CurrentDB pretty much all the time as mostly it tends to be more complex than the 1 line query that this particular thread is about, i had suspicions that creating a DB var was always the thing...

@MajP if i'm working with more than just executing 1 query i have always declared a database variable and used that, it was just in this instance for 1 line of query it just seemed a bit of over kill but i didn't want to not do it if it is something that should be done as a matter of course. i...

ah-ha, i found http://allenbrowne.com/ser-29.html and i can see what you mean

@Mike Krailo thank you appreciate your response, i'll stick with less code. one thing though, what do you mean by disambiguate?

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

@moke123 its an unbound form that updates a set of selected invoice records to have a reference number, status, who it was from, who it is to and the status so the user selects the records from the continuous form and then details what values they want to update on the selected records to say...

so looking a bit more at the code you provided i can see what you have done and i might try and adapt it for my needs but i was trying to reduce the code down from what i had so the update query method of doing all the fields requiring update in 1 line of sql was what i was hoping for but in...

sorry if it wasn't clear the question is, if the user hasn't entered a value in a specific field i don't want the update query to affect the data in that field, so if the form field is blank that means "DO NOT UPDATE THIS FIELD" so the update query needs to dynamically build the list of fields...

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

i went down the route of creating a sharepoint list mimicking the table, a hidden FE form with hourly timed event which updates the linked sharepoint list table from the BE table. its not really an important table/process as its more a backup in case the staff member is not near a PC and needs...

@theDBguy yeah in my searching i couldn't find anything that would indicate that i could link a sharepoint list to an existing table only the other way round in that i can link a sharepoint list into access. so maybe my idea of: Create a list on sharepoint that replicates the back end table...

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

@Cherylodge thank you for your reply, yesterday after the update i was able to do the compact and repair, but now i'm back to the same situation and can't do the process. i have shut down all access to the back end and also the front end both locally and shared via the network and all the...

I have today updated to Version 2202 (Build 14391.20132) and am now able to compact and repair my database, so this issue has been fixed a spart of this update......... who knows what joys i'll find that they've broken in this update ....... but for now this issue is resolved

ok so have found 1 other user in the office who is also unable to compact/repair........... wooohooo..... means its a bug with access and as such i'm doing no more faffing around with installations/repairs/revert and wait for new update

quick and full repairs didn't resolve the issue, re-install will have to wait till monday now but will give that a try then

@CJ_London apologies, i appear to have missed that suggestion above, :oops: i will actually give it a go and see whether that helps, i think i saw repair and thought it referred to the compact and repair business