Recent content by epicmove

It's been a while since I have had to do any access programming and have recently been working on n-tier web applications with separate Data Access and Business Logic layers. It led me to develop a more flexible structure for any insert/update/delete methods within Access. For example a method...

Hi there. I am looking to rationalise some of the queries I have in my access application. Let's say I have two forms that query the same table based on a value they have in a combo box. Currently I would have a separate query for each form and set the criteria to the name of the control on...

Hello. I have created a procedure that runs a report, outputs it in a specified format and then emails the report using a "blat" script (had to use blat rather than sendobject function as user does not have a local outlook profile). Anyway - the above works fine other than the fact that the...

Hi guys. Really struggling with this one. I have written a screen scraping application to retrieve some information from a web site that uses forms authentication. This works fine on my public broadband link but fails at work because of our proxy server. I originally created a web based...

Hi there. Cant really help you with compiling an .exe through a command line (although I believe it is possible). Something you may want to consider is that many mail clients particularly Outlook will block .exe attachments even on internal mail. If the mail is being sent externally it will most...

Hi guys, I am currently trying to fix a VB6 application. One of the main issues is that log data was being written to text files rather than the database. I am therefore changing the application to write these log entries to the existing access db. Unfortunately, as I am more used to .net...

Hi there, its been a while since I last posted. I am working on a new application that basically allows the users of the application to enter projected prices for various products over a series of time. The company's traders negotiate deals with customers as to what we can see the products for...

Hi Guys, Just a quick question - hoping for a quick response :p My Access DB is an Asset Management System. The main table of the DB is Tbl_Asset_Main One of the fields of this table is Allocation_Destination Another field is Allocated_To_Name When recording an asset a user can select an...

Hi Guys, I have had a search round on the internet but am struggling to find a solution to my problem. As an extension to my Asset Management System, I have modified the log on scripts on our network so that when a client machine logs on: a) ipconfig is saved as a .csv file in a network...

Hi guys, Cant seem to work this one out. I have quite a complex search form. The underlying query displays the results in a list box on the same form. So far I have used the following expression for all the fields on my form (whether text or integer values): Like "*" &...

try this....... Function UseForAllButtons () 'put your code here to get button number 'you may need to define a button variable i.e. dim ctl as control 'ctl.controltype = acCommandButton End Sub Private Sub CmdButton1_Click() Call UseForAllButtons End Sub Private Sub CmdButton2_Click() Call...

Hi guys, I have a list box with rowsource "QryListBox" I have SortBy option buttons on my form that change the list box's rowsource depending on the selection made i.e. strSQL = "SELECT " & Me.List.Rowsource & ".* FROM " & Me.ListBox.Rowsource " & " ORDER BY " & strOrderBy 'where strOrderBy is...

Unless you are going to link this to Active Directory i cant see how you can use their network password. suggest using access security

thanks scotty will give this a try tomorrow. thought it would be something like this where I have to pass the frm to the function.......learning all the time :) Thanks again Ben

thanks for explaining and for your help. if it means anything to you, youve made a significant contribution to the search functionality of my Asset Management System Thanks again Ben