Search results for query: *

Hi. I have a form that calls other forms, when it does this the other forms open behind my main form. I believe this to be to do with the 'Has Module' flag being set to 'yes' in the 'Other' tab of the properties window. Has anyone experienced this before? I've copied the form code sidewards...

Hi. Is it possible for a combo box to display columns from more than one table? Thanks.

Hi. I have tblInitialRiskAssessment linked in a 1:1 relationship with tblControlledRiskAssessment. I've created an edit form for tblInitialRiskAssessment but because it's linked to tblControlledRiskAssessment it won't let me save. I'm not changing any primary data, i'm only trying to edit...

Hi. This is probably a simple question but... When you have a form with a combo box on it that selects records how do you make all of the fields on the form display no data until a record is selected? Thanks. Russie

Hi. I'm using the below code to test for the presence of a record in tblControlledRiskAssessment: Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("tblControlledRiskAssessment") If rs.EOF = True Then MsgBox ("empty") Else rs.FindFirst...

Hi. I have a form that is referenced by the RiskID ID variable when it boots. Some of the form header information is generated by using DLookup's. I have 2 indicators on my form that I would like to change the background attributes when the form loads. The attribute will depend on a value that...

Hi. I have three tables. 1. tblSummaryBudget 2. tblInitialRiskAssessment 3. tblImpactScoresFinancial On the summary budget form I have the RiskID field looking up from table 2 (tblInitialRiskAssessment). Is DLookup able to query tblInitialRiskAssessment for a ImpactFinancial value (an...

Hi. I'm developing a risk management program. I have a matrix of possible gradings, on the x axis is 'consequence' ranging from 'Insignificant' to 'Catastrophic' and on the y axis there is likelihood ranging from 'rare' to 'almost certain'. There are 25 boxes in the matrix (5 Likelihood *5...

Hi. I have a column in Excel which contains names in the following format: BLOGGS, Joe I would like to be able to split this list of names into two columns i.e. A B BLOGGS Joe Is this possible with the use of some code? Thanks. Russie

Hi. Does anyone know how I can call a sub in formB from formA? formB posts a journal, formA reconciles...I would like to be able to call sub ' reconcile(strReg) ' from formB. A star as usual for any workable answer. Many Thanks. Russie

Hi. I have a tabular sub-form that is requeried when a routine is run. Is there anyway that I can have a dynamic record source for my sub-form...i.e. if condition = true then strSQL=x and if condition = false Then strSQL = Y. I'm refreshing the sub form using Me.subform.Requery. Is there any...

Hi. I can do practically anything with a CSV file from VBA apart from to simply open it for viewing. Does anyone know how to view a CSV file from VBA code? A star for a correct answer. Thanks. Russie

[ Already Posted on the Access VBA Forum ] Hi. I have a database that, on a monthly basis, can import anything from 8000 to 40000 records from excel into access. I can easily set up an import that deals with named ranges. My problem is how to import using non-named ranges, i.e. to get Access...

Hi. I have a database that, on a monthly basis, can import anything from 8000 to 40000 records from excel into access. I can easily set up an import that deals with named ranges. My problem is how to import using non-named ranges, i.e. to get Access to somehow count the row that have data in...

Hi. I have a cashbook balance (tbl_CBBalance) table set up like so: Region CB_Balance A 10 B 17 C 9 D etc.. I have a form with text box controls on it named so: txtABalance txtBBalance tctCBalance What I would like to do is to read the values from tbl_CBBalance into...

Hi. I'm using queryDef to run a query. 'Retrieve DailyTrans Set qrydef = db.QueryDefs("2_DailyTrans") qrydef("Region") = strRegionParam qrydef("StartDate") = startDate qrydef.Execute When I use strRegionParam = "D Or 51" the return is null when I use...

Hi. I have a set of Access queries that extract data from SQL Server. These queries are using linked tables which i find faster than creating a connection object and reading in each line of the recordset into Access seperately. My question: Is there anyway to pass the 'table to be appended...

Hi. I have 10 standard SQL Queries to run for 10 regions and I would like to pass the regional variable to the SQL string to do this. What is the best way to run 10 SQL Queries, one after another, in code? I've been using... Set conDatabase = CurrentProject.Connection strSQL = " [...

Hi. I have written a db that reconciles the Sales Ledger for 10 regions. The reconciliation process uses 10 standard queries per region. The types of queries used are Append and Update queries. Is there anyway to only use one set of queries for all regions, by passing the regional specific...

Hi. I have a list of text boxes with similar names: txtAvalue txtBvalue txtCvalue I'm using code to run queries and perform calculations. Currently I have to refer to the form text boxes as: [Forms]![frmtest].txtAValue.value = x [Forms]![frmtest].txtBValue.value = y What I want to do is to...