Search results

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

Thanks for this I have the hash for the dates and it works now, and yes the entryid is numeric. I apologize for the late reply...

Thankss for this, i think this is how i already built my FE, everything is filtered according to what the user needs to work on, all forms are bound to queries. If this is the case then, do i simply import the tables to SQL and create linked tables to the FE?

Yes it is related to that post, i actually asked this because i was trying to figure out a solution where i need the numbers in order. Yes the autonumber is pk. I actually figured out a way to fix it and I posted it on the other post. Thank you!

Yes I did noticed that the order changes everytime i open the table. Thanks for this

Hi it'e been a while I apologize as I have been busy sorting out stuff... so the autonumber got messed up and I have child tables related, what I just did was to create another autonumber field, then i switched my pk field to number again, then copied the new autonumber field values and pasted...

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?

It I didn't have time since I was in a rush to add data into it as some people needs to start working on those data, what I did so I can be able to add data was to switch it to Random and it's all messed up...='c I am trying to fix it now, I am wondering why when I autonumber it does not start...

Yes it does....

I am looking at it right now, I am not sure, would you know if this would change the numbers as well on my related tables respectively like would it change the related table's autonumbers that corresponds to their number on the main table?

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

Hmm... I need to find out the entryid_info that does not have a pair in entryid_reso. Like this list of them that does not have a pair in entryid_reso which is in the tbl_notice reso… I hope it's not confusinh...:banghead::banghead:

Need to find out the entryid_noticesinfo that doesn't have a pair in entryid_noticereso. :banghead::banghead::banghead:

Hello everyone I am sorry the 2nd table should be tbl_noticesreso..

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, thanks for this, it looks like adding new data to a table using the Insert query. might be handy in the future, but for now I am trying to update the existing record. Thanks

I have tried that as well, still saying the same error message ='c

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

Right! I realized I have not selected anything yet :banghead: so foolish of me :banghead: I apologize..... :o:o:o