Search results

Hi, I have a sub form that I am filtering by code everything looks fine The filter is fine and correct However, when the form opens one column shows data (correct data) for three seconds only and then the data in the whole coulmn disappears Rest of columns are fine did anyone face this...

Thank you for your time and help

Thanks a lot It worked

Thanks a lot for your reply Unfortunately I can’t share access I can’t do attachments from my laptop I tried to create it this way but I didn’t get what I want I want to put the table data beside the IDs that I got from the query But I am now getting it the other way around if I have three...

How to refer back to the query? deal with it as a table Can you explain more

Hi I find this forum very useful specially when I get stack with something that takes me long time to figure it out I have a query that gets me certain records. I want to merge the results of this query with another table Example: the query gives me a lis of department name from a table Now...

Hi I have a table ID, Unit, Department I need your help to extract the records (not the count ) but to filter those IDs that are duplicates but the department for them are not the same 1 Unit1 Dep1 1 Unit2 Dep1 3 Unit3 Dep3 2 Unit1 Dep1 5 Unit2 Dep3 2 Unit3 Dep2 I...

It worked Thanks a lot!

I am not reading from any table I am just saving data in the list by adding them through a text box an a button to move the text to the list I just need to creat a check before I save that the list is not empty

Hi How to check if the list is empty and has no data if I put len or value=0 It works only if I select a record I just need to make sure that the list is empty without selecting any record

I tried yours And its working fine Thanks all

For some reason it’s not working However I managed to put the count from eqch table in the one query I just need to add one field and creat if statements of the difference maybe Is it possible

Thank you I will try this

If I have product ID 222 222 222 Then I have a count of 3 I am expecting to find the same count in the other table But I am just counting specific status

Hi I need your help in building a query I have (table1) that consists of Product number and status Another table (table2) That has the same information I want to find the count of product ID that are status (open) from each table And show the open product ID in table1 that are not matching...

Thank you soooo much It worked

Hi, I need your help I have a table (table1) that consists of 300 records I need to match few fields from two other tables (table2) (table3) Those tables might have duplicates records but the fields I need are the same even in the duplicated records. I tried right join and left join but it’s...

Thanks a lot for some reason the source didn’t copy well. i noticed that the page is using asp do you think there is another way to do it

I really thank you soooo much for your reply This is exactly what I am looking for I need one favor from you I can’t download the attachment in my device Can you kindly copy the code for me. And the libraries that are needed this will be a great great help from you

thanks for your reply Table that consists of some text information It doesn’t have a password can you please share the code