Search results

Can anyone help please ? I am building a query tool to search for stored docs. In the tables are fields such as DWDOCID(primary key) DWPAGECOUNT(amount of pages) and account numbers. With these fields a calculation is done to calculate the 2 subfolders where this doc is stored. I have...

To get this straight,i want to have use the data of the selected record in a subform

Hi, Can you help me out please,with my recordsource ? Me!GIRONR_subform.Form.RecordSource = "SELECT * FROM GIRONR" I get a failure message,what am i doing wrong ? Thanks,

Ok,thanks,i will take a look into that !

Used fields in the record are DWDOCID and DWPAGECOUNT,with these fields a calculation is made to get the 2 folders they are in,and amount of pages connecting to this record.

Sorry,this code is on the form behind a button to open documents connecting to the selected record, Thanks,

I have setup this code: Public Sub Command4_Click() ' Calculate subfolders,display path and filename and extension Dim intSubmap1 As Integer Dim intSubmap2 As Integer Dim intExt As Integer Dim A As Long intExt = 1 intSubmap1 = Int(DWDOCID / (CLng(256) * 256))...

Hi, I have a problem,i want to get the data behind a selected record on a subform.Right now i only get the data of the first record,not of the one selected,can anyone help me ?

Hi, I am setting up a system around access to search for stored docs,docs are all stored in folders.The records contains all data around these docs.What i want is this,search in the combobox for a nr,the report gives me the result,while selecting a record in the report and clicking a button i...

Re: opening tiff files Guys ? Please Help !

opening tiff files Hi guys, Another thing which confuses me. I have a large access db,containing records with documentsnames,folder and amount of pages,all somewhere else stored docs are tiff files with extension .001,in case of one connected tiff, .001,.002 ,incase of more connected tiff...

Thanks guys,for all your help,2 problems solved,thanks !!!!

i am a newbie,how can i do that ?

combobox wizard Hi, I have 2 different databases,in which i want to create a combobox through the combobox wizard option.In the first database after creating a combobox on the form through the wizard i have 2 options,in the second database,i have 3 options,see attachments.Can anyone tell me...

Hi, I need to calculate some variables: Dim intSubmap1 As Integer Dim intSubmap2 As Integer intDocID = 123 intSubmap1 = Int(intDocID / (256 * 256)) After running the last line i get a runtime error 6:overflow. I ran it also in VB6,no problems. What's wrong in this ? Thanks !

Hi, Thanks,but all the files are single page tiffs,if behind a record more than one file is stored,i have to view them one by one,that´s my problem.I am searching for a solution to view them as multipage tiff,by only using vba access,i can´t use third-party software,it´s forbidden. Thanks...

Hi, I have converted a DMS system into MS ACCESS,to give people the possibility to search for documents.All the data around the docs are in the database,eg the field DOCID contains a docid corresponding to a tiff file with the name of this docid.One can run a search,select a record,and click a...