Search results

strange audit problem ghudosn's audit trail is fantastic - so thanks to that guy strange problem occuring when i run it. on one of my combo boxes - when i change the data it lists it twice in the audit trail text box like below Changes made on 23/02/2007 12:50:15 by Admin; Category: Changed...

hi i found this code here and it works IF the number comes first and is preceded by a letter 123AA but it does not work if the letters come first AA123 here's the code Public Function GetString(WholeString As String) As String Dim i As Integer Dim Temp As String Temp = CStr(WholeString) For i...

the original problem still stands. boblarson - you are reading the question backwards. i do not need the data to identify the photograph even though the data is correctley stored in another table. i need the data that i collect in the 'field' to confirm that i have matched the correct...

thanks for replying this text box in my record serves no data purpose whatsoever except for me to see that i have correctly matched a photograph to the actual record. all the information in this text box is contained elsewhere in seperate fields. this is not actually a problem but seeing that i...

hi I'm no expert and can't seem to find what i'm looking for. i have data i enter into a text box. the data might be in the format "name" OR "name, date, age" OR "name, date" if on the second or third example above i entered the data like shown below how would i VB code the afterupdate to do...

thanks for the starting point. the data concerns dead people so it will not change. this particular information is what is taken off the headstone so that i can check that i have correctly matched up the photograph, it serves no other purpose. this data exists elsewhere in my database and is...

looked around but could not find the answer. i have a text box that might or might not contain text and number data. an example of the data in the text box might be; bob roberts, 17/03/2006, aged 23 what i would like is some VB code that would: check anywhere in the text box for number...

thanks for the reply i tried the above code keithG but it did not work. i can only setfocus when i click on the subform, then the control that i have setfocus to becomes 'live' and the cursor goes to a new record. in which case why don't i just click in the new record itself which is what i do...

yeah - thought about that but not sure if it would work and yes it is bizzarre trouble is as i am checking each grave for health and safety reasons i find that the data in the burial books and the data 'on the ground' , in most cases, does not match and as i'm dealing with relatives of the...

i won't go into details except i am doing databases for cemeteries - very complicated example i have come across two people who have the same name, date of death, buried in the same grave on the same day but are not related and must have seperate records!! my main table has 6 primary keys. [even...

the problem seems to have corrected itself if i disgard the macro and write it in VB code. still can't figure out why the macro would'nt work though? the code i used is Private Sub cmdsnapshot_Click() On Error GoTo Err_cmdsnapshot_Click Dim stDocName As String DoCmd.OutputTo...

a possible solution which i am now using is to assign all my records an autonumber. this way if i know that the records i want to print out [using another search criteria] are between autonumber 1-100 then i can search for the records i want using the autonumber as the search criteria. ie print...

hi i am using a macro with the outputTo method for a report. i have the report outputed as a snapshot file. it was working fine but now when it outputs the report the extension is missing; the file is created but with no extension. i tried changing the output format to excel but the extension...

hi very simply i am trying to print out a report that is comprised of 1 main report and 2 subreports with 1 image per page; all together on 1 page. i can print out 20 records maximum before my computer memory [or the printer memory] becomes full and the printing stops. the same happens if i try...

the answer to the above, which works for me, is to include the image path location within one of the 2 text/data queries [this is my link to the image query], copy the query the image box uses as a data source within the report, create a duplicate query with criteria *001.jpg and use this query...

hi i have created a form bringing together 3 queries. one of the queries contains images the other 2 queries are text/data information. i am now creating a report to print out the queries. each query is made into a report and then combined with a main report [2 of the queries are subreports]...

hi i have 3 queries brought together in 1 form. i do not want a report to be printed out just the current record in form view. this is because i have a number of images per record. if i print out the current record and it only has 1 photo in a sub-form attached to the main form record, then the...

finally cracked it so i thought i'd pass on the answer to the above. at the oncurrent event i needed to type the code Me.Form!photo!cempic!.Height = 6500 Me.Form!photo!cempic!.Width = 5000 because the form showing the images is a subform. the large numbers used are because access uses the...

thanks for the reply i've tried that and the image disappears. any ideas why? [perhaps i have to define what me.cempic.height = 4 means??] i've also tried Me.cempic.ImageWidth = 3 Me.cempic.ImageHeight = 3 but i get the error message that this property is read only. [there is no read only...

thanks for the reply my zoom code is Private Sub ZoomIn_Click() Dim Hght As Integer Dim Wdth As Integer Hght = Forms!memorials!photo!cempic!.Height Wdth = Forms!memorials!photo!cempic!.Width Hght = Hght * 1.2 Wdth = Wdth * 1.2 Forms!memorials!photo!cempic!.Height = Hght...