Search results

Hi, hope all is well . I was looking to update a date column in a table and was trying to do it by a button with VBA and seem to have got into a fankle. (ive been messing with python and getting confused now with vba). Im trying to update a column called "PM Due" in a table tblDataLog which...

Hi all hope all is good. I seem to be getting an issue with Dlookup checking a table for a value and returning the correct response. I had a similar question recently and the dbGuy helped and noticed i had missed single quotes for a string search. I've tried various iterations of : Dim RPSno As...

Hi, Hope all is well. Just a question if anyone has time. I have a piece of code i was using to check if a record existed in a table and seemed to be OK . I had thought of using it in another entry form , the ID on this new form having letters and numbers instead of just an integer. The code...

Hi, hope all is well. I was trying to extend a query that I had for getting the top 10 results by making the selection variable i.e. top 3 top 7 . The only way i could see to dit was taking the query and using QueryDef and VBA to run a module that would allow the SQL to be modified reading from...

Hi Hope all is well, I'm hoping someone can give me an explanation please to what I'm doing wrong here. I've got a query that I was using to calculate the days open on an unclosed entry. I then found a database from pat hartman that excluded weekends...

HI, Hope all is well. I have a query that is fine if I was to use the start and stop times on the hour, I'm trying to learn a bit more and try some changes so I've been trying to alter it to try and stop and start at separate times e.g. instead of between 7am to 8am trying 7:30am and 8:30am. The...

Hi, Hope all is well. I was wondering if someone could help me out with a date formatting issue I have. I've been using a bit of code for date formatting and now that I'm trying to use it to find the previous date I think I'm doing something wrong. Dim DT3 As String DoCmd.SetWarnings False...

Hi All, hope all is good. I have a question I cant seem to get an answer on and I was wondering if it is possible . I've attached two charts I produce on a database showing cases still open and cases closed. My question is can I combine the two charts into one and keep the formatting i.e. closed...

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

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

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

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 All, Hope all is well. Im trying to add an object selected from a dialog box into an attachment box on a form with the intention of then saving the object to the attachment field in the table. Ive read this isnt the thing to do, but im trying it for two purposes (1) I don't trust the few...

Hi, Could someone point me in the right direction here. From a query I've made a report that works ok and gives the relevant data. see below as you can see the pass and fail columns in the current total sum as new data is passed each hour using the the report function ..Running sum > over...

Hi all, hope all is well. Im putting together a new database to work out passes and fails an hour and resultant percentage yield and i've got a couple of quandaries just now im hoping someone more enlightened can pick up. The code seems to work and produce the desired results, but if i try to...

Hi, hope all is well. I'm trying to add a button to an access form that will add a more frequently used attachment to a table. I'm getting the following error . Run time error 3852 cannot update a multivalued field if its parent recordset is not in edit mode. To place the parent recordset in...

Hi, Hope you are all ok. I've made a form that sends out an email to named members about an issue they have to look at. The email contains a link to a database which opens a specific record, this is ok. The issue I've noticed is if you shut the form down , when you reopen it it still links to...

Hi, i have some code I'm using to send an email to a user indicating that a database needs their input . What I've been trying to do as an extra is have a link on the sent email that when clicked opens the form that needs viewed. I have used the code below to open the database form with the...

Hi , ive put together a database that records when a user has viewed a safety message for the day and also the ability to update the database if they miss a day by using an update form. What ive been trying to do is have the user notified on logging in that they have missed a day on a certain...

HI, Im trying to use some data i store in a database to give me running percentage yields to hours . What i have is a bit flaky. the code sometimes works and sometimes doesnt and when it does it doesnt tansfer to the report. The part i thnk i have the problem with is on the join in the query...