Search results

Hi alexkong2003, Does it compact and repair? What occurs when it compiles? Can you make an mde? Robert88

Hi Did you try "compact and repair" and also compile it before making a mde? :eek: You have to keep you eye on two files now, the original mdb if design changes are needed later and the latest mde. Robert88

Hi alexkong2003, If you make an mde from your mdb it will protect it from design changes. Robert88

Hi plucnik, You could always consider reading in all files with http://www.access-programmers.co.uk/forums/showthread.php?t=101435 Once you have them all in a table you could include date and time info and then sort to get the latest in a query which would give you the latest file, assuming no...

Hi mudster01, The F:\ Drive you mention will be a network share, that share will have a computername and network sharename. You could substitute it for \\computername\sharename\......... Good Luck Robert88

Hi Matthew, Let me know if you have any further problems as did this on the fly. Already noticed that you will have to substitute your form name. Good Luck Robert88

Hi mdcory, A Little insert is required. Option Compare Database Private Sub ScannedBarcode_enter() On Error GoTo Err_ScannedBarcode_Click Dim stDocName As String Dim stLinkCriteria As String Dim stFormName As String Dim MystFormName As String 'Check for Null value of...

Hi mdcory, Shouldn't the red above be Click? And the code should be in the button and not the form when you enter?. Due to the txtScannedButton being blank when you first open it the code does not handle a null value and hence the error. One option is to give the txtScannedButton a default...

Hi Ziggy1, Creating a VPN (Virtual Private Network) will allow you to take more control over the WAN connections in case you are concerned about security of the information?:cool: If security is an issue, it then depends on how much importance your company places importance on the...

Hi RickieB, Is there any options as part of snapshot viewer which allow different page set-up options at both ends to be different?:rolleyes: Robert88

Hi f_disk, Use a parameter query and within it use information on your form to govern what information you need on your report. Once you have the parameter query correct with the info in your subform use the query in a report and show the report on the screen. Hope it helps. Robert88

Hi prometro http://www.access-programmers.co.uk/forums/showthread.php?t=101435 This will help with getting folder path and file info into table, hope this reference helps? Robert88

Hi tubar, What about one text box which requests the record number and one button to open the form required? I just used a query to search the text field before the button is clicked. So in the Button number field just type a number between 1 - 118 and you will get your result? Check the...

Hi tubar, A few questions. How many of these forms are required simultaneously? What governs the record number required? Look forward to some answers before proceeding to solution. Robert88

Hi mdcory, No Problems, glad to help. :D Robert88

Hi Matt, Really testing my memory here. In control panel you will find a ODBC icon, within it you will have to create the same link that was previously created in order to connect the ODBC link that is required, but cannot find (your hourglass....). Hope it helps. Robert88

Hi Alhousani, If you are running this from a network share at work is the database split? If not then by splitting it and leaving the back-end on the server and bringing the front end to your local client, means your local client does a lot of the microsoft access grunting instead of hogging...

Hi Karen, Changes in red, Let me know if that helps as have not tried it. Robert88

Hi tubar, just quickly. Create a query that will open the record and then include this query for the form record. Robert88

Hi mtagliaferri, Don't normally suggest this but if you create a macro "autoexec" and within it open a form and maximise, does this solve your problem? When I scout for a VBA solution I will let you know, as interested myself, always learning..... Robert888