Search results

Something like this. This is a database example from Microsoft... clicking on the quote "1006", "1007" will open that particular form. I can see that it is done with a macro

Well I could refer to the PDFs stored in the network but wouldn't it be easier just to produce a new report based on the ID on the actual row? What if I want to open the form on the record given by the ID on that road? I can do that with a Macro, right?

Apologies, I think that I didn't explain myself properly. I need a link for the reports on the query results. I have already a button on every form to show the report. I would like to access to if from the query. If I look for case 234, I don't want to go to the form and look for the ID 234...

I just need a link to the report and one for the form if this is possible. I just want to be able from the query results to open the form or the actual report.

Sorry. I have a case registration table and from the registration form, I can produce a report for each case (basically an invoice). I have a split form to search on all the cases using a query that I did for this purpose. I would like to include in this query (if possible) a link to each...

Hi all, Is it possible to generate a link to a report (associated to the respective ID) on query results?

Thank you! It works perfectly!

When I do this, the "append to" and the criteria "Is Null" disappear as well and it attempts to add all the records, not only the new.. Edit: It seems to work when I create a query from the unmatched query and append this one.. Thanks a lot for the help!

I did the unmatched query and it finds the new records. Perfect! The results of the query are perfect and no columns are duplicated When I change from select to append and I try to run it, I get the error "Duplicate output destination 'CaseNumber'" In the query details I have...

How can I make sure that when I do the query append, I add only non-existing records? I have a "CaseNumber" field that should be unique.

Sorry for reopening this again, but I need to be sure that I understand correctly. What you are suggesting is that after importing the table from excel (Tb1), when needing an update, I create a new updated table (Tb2) and append the records to the first one (Tb1). After that I should delete...

It says that there is a problem with the formula if I don't do it.. I solved it referring to two cells with the values 7:30 and 8:00 instead. It seems to work. Thanks for your help! :)

I have a table in excel that's a query coming from an access db. I created a couple of columns at the end for different calculations and I am having troubles with the results since those matching a condition are not formated as "date" like the others. My function is...

* I would have to refresh it probably every day or every other day. It would be around 70 new rows every day. * The idea is that multiple users will be using the same refreshed data, so it will have to be imported in the back end, if I'm moving away from the linked table *If the refresh happens...

I would like to ask for a suggestion on which is the most appropriate way to do this. I have a dynamic excel sheet that now is approx. 36.000 rows. I need to auto-populate some fields in a form using this sheet. Would the right way to do this be to import the sheet into a table on another...

Thanks, I'm not trying to write in it. It is used on a read-only basis to auto-populate a couple of fields in a form.

Dear all, I have a DB with a linked excel spreadsheet. It is used to auto-populate different fields on a form. The database is split and when more than one user are working on the same form, we get the error: "The MS Access database engine cannot open or write to the file G:\myfile.xlsx. It...

Thank you! It was the backslash!

Dear all, I am getting this error on the below VB for a button that should create a folder and place a PDF of a report in it. The code is working on another report created previously and I just updated the FilePath and FileName. It creates the folder correctly, but I get the OutputTo error...

I have just realized that I should solve this in the query itself, not in the report. The issue is that I have a checkbox field and a calculated field. The calculated field will always produce a number, but if the checkbox field is active, I want that number to be "0". The question would be...