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 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 "*" &...

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...

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 =...

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...

Hi Guys, The asset managment system I have been developing is due to go live next week and I am really struggling with the data entry and search forms. I have attached a picture of the main form (and outlined each subform) to give you an idea of my project. The attached form is actually a Main...

Hi guys, Just want to check to see if a text file exists. If it does, then open it. If it doesnt, display a message. Have written the following code. Wondered how I can use the FileSystemObject to actually open the text file rather than using the Application.FollowHyperlink. Still learning VBA...

Hi guys, I need to finish the Asset Management System I have been creating today. The main Asset Form works fine for Data Entry. However when I view existing records, the Model of the Asset (I.T Equipment) appears blank. The reason for this is: I have three tables linked in the following way...

Hi guys. I hope someone replies to this thread....I am struggling with this one. I am developing an Asset Management System for our IT Equipment. We wish to record the software installed on each PC. The Manufacturer and Software names are stored in separate tables. The AssetMain table has a...

Hi guys....im really quite stuck now. Original Problem: Cascading Combos on continuous forms. Changing value of combos changes all combos on form (although underlying data is not changed) Original Solution: Created unbound combo boxes on form header. Used the following code to add a new record...

I have three tables with relationships as below (where > is "one to many"): Manufacturer > Model Group > Model. I have a table called Asset. The Asset table has a field named Model On the AssetEntry Form the Model Field is a combo box that gets its values from the Model table but is filtered...

Hi Guys, I have two unbound cascading combo boxes on a form that limit the data for a stored field. I am designing this as a subform to show software installed on a PC (hence the need to have a continuous form). As the manufacturer, software package and edition are already stored in my...

Hi guys, Just a quickie about Tab Controls. So that I can format them to match the rest of my forms, I have done the following: Set the backstyle of the tab control to transparent. Changed the tab control style to None (after creating the individual pages). Placed buttons on the main form with...