Search results

Thanks again arnelgp for the help . i also changed the ORDER BY tblRma.text4; to ORDER BY tblRma.registered;

HI arenelgp thanks for the quick reply. The data I'm getting isn't matching to what I'm after. I was looking for the oldest top 15 in the query and I'm still getting the wrong data. Here's the query I'm using to get the top 15 oldest SELECT TOP 15 tblRma.text1, tblRma.text2, tblRma.text3...

Hi, Happy new year and hope you're all well. I have a query searching between 2 dates, it was working ok last year but i think its not working due to formatting now we're in 2022(?). The query I have is : Between DMin("[registered]","tblRma") And DMax("[registered]","tblRma") where I'm looking...

Ah, The data is drawn from a text file a tester produces and this text file is inserted into a table, the comments is just a visual help to anyone walking past why there was a problem that hour it wasn't meant to be retained , the data on the screen was just to be a visual of what was going on...

Hi Pat, I'm trying to redo a touchscreen board I did in HTML/javascript which I've attached a pic. The current screen the user types in all the data and any comments that have happened that hour, the access db is looking to make it more automated and pulls the data from a text file, the only...

ok thanks for the reply June7

Hi, I'm looking for some advice as to what I'm trying to do is possible. I have a database that pulls data in and allows yields to be checked each hour and displayed on a form, this part seems ok. What I was trying to do was add a field for comments that could be added for any issues that hour...

Thanks for that cl_london that seems to have done the trick and thanks arnelgp for the delimiter explanation clearest ive seen. thanks to all that replied, as always well appreciated

Hi Thanks for the replies, here's the table they are from....and i do need to update the textx fields to a better desription thanks

Hi all , hope all is good. Could someone explain please where im going wrong with this where clause, initially it was ok as the criteria only had one argument, now that I am trying to use two criteria in the query I'm getting RTE 3464 datatype mismatch in criteria. The initial query I had that...

Now that I've got more reading into it, it does seem to be a no no attaching files to the table which I get due to the bloating of the dB and the 2Gb limit. It was just interesting trying.

Thanks very much moke123 that's very useful to see how coding like this is properly done

Thanks again DBguy ill give that a go since you've recommended it

Thanks dbGuy, my main holdback is I need to get a better understanding of vba from the bottom up instead of trying to patch it together

I've got the clown shoes on today...just noticed when i used the msgbox ..the boolean field is removed.......registered is a date....DOHHHH!

Thanks arnelgp

Hi, i got round this by making the attachment boxes bound to the table so that that attachment boxes work as normal when clicked (ie the paper clip appears and allows an attachment to be made) and if anything is added the attachment links to the correct field...thanks for your suggestions

Hi arnelgp thanks for the quick reply, I tried the code there and it still opens the form if the registered field box is ticked in the form and if the number doesn't exist in the table nothing happens when i click the button, its the boolean part i seem not to be getting...thanks again

Hi all ,,I'm trying to check a table which has a Boolean field before a form is opened, the idea being if the Boolean is true then the form will not open. I already had a check in place which tested if the id number ([text4]) was in the database before the form was opened see below If...

Hi moke123, if i get this working i might try both (hyperlinked and record attached), but i think the file attached to the database is safer for the users as it locks the file to the record , i tried changing the filepicker to 3 but the error was the same