Search results

I'm using a dictionary to build a list of keys and values. The keys comes from a recordset (stringfield), the items are Excel-columns (A, B, C etc). The code determines the Excelcolumn based on a "columnname" in the table Meta by searching for a column with the corresponding name, then gets the...

In a certain database I'm setting (square-sized) images in a table in word. The code should handle 1 or two images in a table in a wordtemplate. The code finds the correct table, add a column if needed and places 1 or 2 images in the cell (or two cells) wTbl is a word table object and in this...

Old post, but it helped me: DSN-less connecting left me with "un-updatable" DAO-recordsets using DRIVER=SQL Server DRIVER=SQL Server Native Client 10.0 also didn't work, but DRIVER=SQL Server Native Client 11.0 worked, thanks

I have some thing to work with, thanks for your replies.

Thanks for your quick reply 1. Firstly I'm no expert on indexing. There are a few indexes on the table and the actual code filters on the table-key (which is also set as UID and thus automatically has an index). I'm assuming that when the UID field has an index (it gets one automatically) and...

I have this database, MS Access front end on a SQL database (SQL Express server) with an ODBC-connnection. Everything runs quite nice - even thought the connection to the SQL-server is bad (bad network, cannot fix), however I have one problem/challenge. Backend used to be Access, but I'm...

I have learned that select * from tbl where [f1]="search1" or [f2]="search1" followed by select * from tbl where [f1]="search2" or [f2]="search2" on the recordset of the first Is the same as: select * from tbl where ([f1]="search1" or [f2]="search1") and ([f1]="search2" or [f2]="search2"])...

Yes, maybe I'm mistaken, but the result of select * from where [naam]="search1" and "search2" or [address]="search1" and "search2" is not the same as 1) select * where [naam]="search1" and [address]="search1" followed by 2) select * from where [naam]="search2" or [address]="search2" (on the...

Anyone have thoughts on refreshing a recordset based on a recordset (based on a recordset etc)? Or a different way to have a searchfunction that searchs in the "last" searchresults (on and on) Have not found a solution for my problem yet

Good tip, I'll try that for sure

Yes, that's what I did in the past, and it enables a user to enter one search, and every time the user does this the search will be done in all records. What I need is: listbox: 1000 records search 1: 100 records left from 1000 search 2: 50 records left from 100 (so, find 50 records in 100...

Why not, since it's possible? As I said, I've never used a recordset as datasource for a listbox, but in this case it's part of a solution (although it creates a new problem) As I said, I need the user to be able to narrow down the records by searching multiple (as many as needed) times in all...

For a database (Accessclient, SQL-backend) I'm creating a form with a searchfield. The form holds a listbox lstObjects that displays records (based on a rowsource SQL, not a recordset). After finding the wanted record it needs to be edited by opening an editform. After editing records the...

I don't open the PDF (perhaps I should include the false' explicitly) after creation from the Outputto command (at all). My machine is a fresh install, PDFs are currently linked to MS Edge, and I don't think Access is "run as admin" by default? (Of course, I'm currently logged in with an...

And still in 2015 ;) Same kind of code, same problem: I kind of randomly get this error when trying to output a specific report to separate files based on 10-30 records (per "project"). In my case, my separate PDF-files get saved in a "project"-directory (that gets automatically created in a...

Could be, I believe I found it on some page where the author of CPAU explained some possibilities

Tnx, but this didn't work, but I found the solution N:\Guideline\Ontw\10_Ontw\cpau -u Domain/User -p Password -ex "c:\windows\Explorer.exe \"c:\temp\test 1.pdf"" I need to add a \ before the second path. This tells the system how to handle the second quoted part. Don't know the exact details...

I want to open files from a networklocation from VBA, only normal users don't have access to that location (and should preferably not get it). I instead of using shell("explorer.exe filepath") to open files using windows standard app for the file, which needs userpermissions to the path the...

I didn't mention this explicitly, but my table have proper PK/UID (RelatieID, AdresID). Its the VIEW that I need to link with ODBC, and when I tell Access "RelatieID" is a UID for the view - while linking the view - it goes wrong. RelatieID is the UID for the TABLE Relaties, not for the view...

I solved the problem: it's caused by the fact that I selected the RelationID as UID in the prompt that you get when you link a table/view. When I cancel that prompt (and don't tell the system there is a UID in the dataset, which technically there isn't since the RelationID isn't unique in this...