Search results

Hi Good day! Please help, I cannot figure out why I am getting type mismatch error here. pbrootcause1 is a combobox with a query as a rowsource, not sure if this is what is causing the problem. When I go on debug, all the variables have values. I have set them all up as a string, not sure what...

Hi Good day! It's me again running into another problem. When the database is opened on other computers, This specific data a specific person has entered cannot be seen. I have tested three different computers. But when I tried to open the database on this person's computer, I was able to see...

Hi everyone! Good day! reaching out for help as I can't seem to make the insert query work. ='c I have checked everything, this query is within a VBA code, I checked this on the query builder and it works it just does not work within the vba. It is supposed to be saving data in a certain table...

Hello everyone, reaching out again for help :o:o:o I have a BeforeChange Data Macro SetField to set a default value on another field. Basically I just want the field to have a default but would need it to be editable, it should be able to be changed as needed. However I found that once I set...

Hi, Good day! It's me again, I have come across another problem I have been staring at for the past few days and I can't seem to figure out the problem. This is an update query. I have attached an image to with snapshots. I was trying to update a certain field in a table where the entryid is...

Hi, Good day! Reaching out again for help.... I did an autonumber field and why does autonumber started at 2 with 1 around the middle and 4 in the last? How do a fix it so that it will be in order?

Hi good day! I have several questions for the past few days and I may not have responded to it yet and now came across another problem. I have a table with several tables related to it through the autonumber field. Now this autonumber messed up. I was not able to add new record saying that the...

Hi, good day! hope you can help, I have a field on one table and I would like to know if the data exist on another table. Can't figure out how the query would be pls help. Table 1: tbl_noticesinfo - table where the field I am looking for is. The field is entryid_info Table 2: tbl_noticesinfo...

Hello everyone, hope you can help. I've been staring at this code for hours and I an unable to figure out what is wrong. It is saying Too Few Parameters Expected 2... :banghead::banghead::banghead: I checked the controls they all have values. I have another one like this on another form and it...

Hi everyone, I hope you can help. This is driving me crazy. I have a query that was previously working literally just a while ago and suddenly I am getting "Invalid Use of Null" I cannot see the cause of this problem. What could be causing thissss? The query, I checked all fields while on debug...

Hello everyone, Good day! Reaching out again for help... Is it possible to create a form where it displays a certain set of records then I can select some and batch update them? Something that looks like this image attached.... :):):)

Hello everyone, good day! I hope you're all doing fine. So I have this formula because of your help guys and I need to add another condition that will ignore these conditions if the condition is met. This one determines the priority based on Age, however I need to have it ignore this based on...

Hello everyone, hope you are all doing fine. I hope I can get some help on this code I found by googling. This always says I have Invalid folder path. I don't know which I causing the error. Here's the code: Dim fileName As String, fldrPath As String, filePath As String, strusername As String...

Hi, good day! Hope you're all doing fine, reaching out again for help. I found this Db (See attached) on this thread https://access-programmers.co.uk/forums/showthread.php?t=240120. My question is, where does it get the holidays? Is there a table or somewhere where the holiday dates are stored...

Hello everyone! Reaching out for help again, I have a form that is based on a crosstab query, and looks like this (Image attached) when the query does not have results for example in "High" column. How do I get it to show nothing if the query has nothing instead of it showing "#Name?"? Thank...

Hello all, good day! I apologize if I am opening up a lot of thread lately, just can't figure out how to do stuff...I really appreciate your help everyone! So I have a list of let's say approved companies. I would like to update a field on a table based on this list. I have a company name...

Hello, starting another thread again, thank you everyone for your patience on a beginner like me I really appreciate it. so I need to be able to make sure that there will be no required fields that will be left blank. I attached an image of how it looks like. * Ext date, InVoice count, LF...

Hi! Here I am again asking for help, I have a little plus sign on my table. It shows on the image attached. When I click it, it says "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try...

Hello, good day! Reaching out again for help. I can't seem to make this expression work properly. What I need is if the value of the field is: <-2 "Emergency" -1 or 0 "Critical" 1 "High" 2 or 3 "Medium" >3 "Low" The expression I have is...

Hello everyone! Reaching out for help again, I have a datasheet form (image attached). I have made one of the fields displayed as hyperlink, I am trying to make the "hyperlink" show the "contents" filtered in a form view upon clicking on the "hyperlink". I tried the openform macro and on the...