Search results

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

Cracked it......thanks Mark!! Ive cracked it. I found the problem was that I was being a plank :) I mentioned that i didnt want to place my SQL in VB as it was too complex. This was the same reason why I didnt want to specify my SQL string in the rowsource of my listbox....so what did I...

Impressed am I Mark, Nice work. Gets round me having to use option buttons to sort the fields. I Understand the Select Case X Statement, but how does the following work?: If Y <= 705 Then If Right$(cboSales.RowSource, 5) = " Asc;" Then..... Unfortunately this still doesnt get...

Hi, I have a list box based on a quite a complex query. I would like give the user the option to dynamically sort the list box. How can I refer to my listbox's SQL rowsource and add a sort order using VB? i.e. Private Sub CmdButtonSortByName_Click Dim strSQL as String strSQL =...

yes I am aware this works. Not what I am after though. I do not want to embed the image as this will contribute to the file size of the front end. The idea is that the image folder can be dropped into the same directory as the FE. However the above function can only be run on one form at a time...

Hi guys, I have written a function to link CmdButton images on my forms. This enables the .mde to be installed anywhere and as long as the images folder in installed into the same directory, the images will show. The function (not exact as its on my other PC is as below): Public Function...