Search results

Last year I implemented Allen brownes audit trail into my database, by adding the audit trial field into my table. So for the last 12 months I have successfully captured any changes to by fields. ( I cannot see this original code I used but i added a field to my table instead of creating a new...

Thought of this, but the original table contains over 1000 entries. I over write this table every month, with data provided by someone else, so i don't think this option would work. Sent from my SM-T715 using Tapatalk

Thanks for this.. I did add the Me. Code when I came to running the code. The values were all in a table originally, but I have other values in that table as well that I don't want to use as part of my criteria. Hopefully tomorrow I will have a bit more time to look at the table. I am...

Worked like a dream.

I have the following code, now the lblsource could be upto 10 different values, So how do i do this instead of having 10 different "OR"s ? If tbrootcause = "Packaging" And lblsource.Value = "Brand" Or lblsource.Value = "UK Landed Indirect" Or lblsource.Value = "UK Landed direct" Then

i think i have sussed it due to the above, the code runs on a afterupate event on the TBCatNo field. This copies the data from one table (Which holds live information) into a second table (TblQCProducts) which i have created to archive the data.

This really helped me out, I realised that the cost price was already being pulled into a text field on the form, so instead of recreating the join in vba I amended the code to pull the value from the text field. I also added the direct price to the form at the same time.. The other fields I...

Thanks for the replies guys, unfortunately I can't capture the information before the update event, as the info depends on the update. Came across another issue late on, the line description fields that is being imported sometimes contains apostrophes, so i might have to run this as a query...

I have a after update event on a field that takes approx 15 - 20 seconds to run, The event code is below. Is there any way to let the code run in the background without the user having to wait for this code to run ? I used to run this as a append query overnight, but have had to stop that...

Excel sheet attached to try and show what i am trying to achieve. The first 7 fields are exported straight out of access as a select query. the 8th field is a formula that i have to input into excel, and is a check for a unique reference and if unique give me a "1", if duplicated gives me a...

Looking at the Jpg, Bmp files the jpg is 184kb, and the bmp is 1500kb. so both files are relatively small and should not increase the size of the database like that. I will have another go on Monday and try and find out what i am doing wrong.

Yes.. compacted and went down to 274. It was a jpg, so i will try again with .bmp. Thanks Sent from my SM-G950F using Tapatalk

Quick question, On my forms i have a jpg of our company logo embeded into the 20 or so forms. I decided to change this, so I linked the picture from our network to the form and the size of my database increased from 12mb to 300 mb. Cant see why this would happen, as i would imagine a linked...

Approved is a text field.. Thanks.. I will change the code tomorrow..

OK, managed to work through it, and your code is correct. Fount that the issue is on some code that i have on the report. which is below. Strange that this code works when i use the suggestion by arnelgp below, but not with your code. This code is in the report header section and is used to...

Ridders - I have not been able to implement your code above as is seems to stop automatically after running the Docmd.OpenReport. Any ideas Why ? the report looks fine if i open it directly, and you are correct in assuming that the Job_ID is a number. also, in the code above you had...

I do have a query that pulls all open jobs together in one place. I was thinking of creating a cascading combo to filter my criteria and then the list box for the final selections. How would I do this using your method Pat Hartman?

No worries. The forum figured it out eventually..

I used the - 1 as suggested by arnelgp up above. > 1 works. or >0

Still got the same issue with the IF me.lstselection > -1 Then If i hover over the me.lstselection it says the value is Null.