Search results

Thanks very much for your help. I am attaching another database I had a go with last night, using queries to ( I think) generate what I was after. I just realised that the queries were clunky and I would need to guess the depth of the site, and that would hopefully more an elegant VBA way of...

Hi Jon. I will be giving this database to colleagues to use. The database is quite developed already and I started the access version in the late 1990s. This element of trying to bind in some functionality from the recorded archaeological relationships is a new departure for me. The database...

8 is a cut - this has been dug through 7 (i.e. 7 had to exist before 8 was cut through it). 6 is the layer that precedes everything else. 12 - 2 is a single deposit. Sometimes single deposits get recorded twice by say different recorders on different occassions. These numbers get recorded as...

Thanks for your reply. Attached a gif showing a section through some simplified deposits and the 'matrix' that I would like to create. I have also uploaded an mdb that contains the 'contexts' and 'contextrelationships' that are recorded in the section. Also a screenshot of a form from some real...

Hi people. I am writing a deposit recording database for archaeological layers. My units are recorded in one table, and then the relationships are recorded in a separate table. I have limited the recording of relationships to be either "same_as" or "below". So in tblContexts is have say...

Ok I looked a bit harder for a function to close down Adobe Reader, and here https://social.msdn.microsoft.com/forums/office/en-US/9a26bda2-6cb1-4024-bcf5-464acdc96170/closing-pdf-files-that-are-open-via-vba I found this: Sub TerminateProcess() Dim strTerminateThis As String Dim...

Hi there. I am using the proceedure above on several projects now and finding it really useful helping colleagues in making a direct link between a database and a PDF with related information. I would like to be able to use it to search an already open PDF but my attempts are failing. One...

With other folks help, I have this code to run on an On Click Event on a Form Private Sub Lettertxt_Click() Dim strPath As String Dim Searchmem As String strPath = [Filelocation] Searchmem = [MemID] pat1 = Chr(34) & "C:\Program Files (x86)\Adobe\Reader...

Success! Lovely job:) thanks very much

Hi people, I've been working at this for too many hours in my amateurish way, and it's turned into:banghead:. I have searched for bits of code to copy other people better than I, and had some success but I am failing to complete, so it is now time for me to visit you all. I am trying to open a...

Thanks for speedy reply. M

Hello people, have spent a few hours on this today, and I am not getting anywhere. I want to apply a filter in VBA to exclude records based on a value. So what is the negative of this DoCmd.ApplyFilter , "[FirstName] = 'Anonymous'" Help please, I am getting a bit frayed! thanks :banghead:

Thanks very much. I added this module to my Path retrieving function : and then in a Text box on my Open Menu added the Data source This does what I want. I don't do this stuff very much, so I am pleased. If I written anything that should be corrected/improved please anyone correct away...

Hi database people, I would like to use a Database's "Application Title" (File, Options, Current Database) in a text box on a Form. For front end path I use =[CurrentProject].[FullName] and for the Back end I use =GetBEPath("tbl_name") and I thought it'd be useful to Code in the database...

Couldn't see how to include what I needed in a function, did some more research and wrote what I needed into query grid design. In query grid: Easting5: IIf([EastingN]<100,[eastingN]*1000,IIf([EastingN]<1000,[eastingN]*100,IIf([EastingN]<10000,[eastingN]*10,IIf([EastingN]<100000,[EastingN]*1))))

Thanks for that. So how would I include the 'If' ,'then' and 'else' clauses I posted a couple of messages back? My source coord is EastingN which may be 3,4, or 5 digits, and I need to make it 5 with the code.

I am bit too much of a novice here.... I have packed my data into an .mdb - would anyone be kind enough to show me how a function in a module that includes my vba would look? thanks

Ah, yes, of course, a penny has dropped. I have used and adapted modules for what I have needed to do, but never created one. I better read up on what I need to do. thanks

Thanks for reply. In my form I have the following VBA triggered on Current to convert 3, or 4 figure refs to 5 figure. I can see that the form is the sticking point and that stacked queries are what I want, but where/how would I run this code in a query? Fields: [5Easting] is 5 digit Easting...

Hello people. I need to populate a table with Grid reference values consisting of 6 figure integers, eastings and northings. I am receiving/downloading the Grid Refs in a UK Grid Tile format, with 3, 4 or 5 figures preceded by letters. eg SK 456 849, SP 6789 4356. I have used some query...