Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 3.03 seconds.
Search: Posts Made By: CJ_London
Forum: Queries 03-17-2019, 03:40 PM
Replies: 8
Views: 116
Posted By CJ_London
Re: Update multiple fields in one table from multiple tables

This comment doesn't really fit your requirement as described but one other thought - is the data you receive normalised? If not you may find you get better capacity by moving the data to normalised...
Forum: Reports 03-17-2019, 06:04 AM
Replies: 10
Views: 168
Posted By CJ_London
Re: weird behaviour of calculated fields

a lot depends on whether your tables are structured correctly and properly indexed. From your description you are using quite a complex method for something which should be fairly straightforward....
Forum: Forms 03-15-2019, 02:52 PM
Replies: 15
Views: 176
Posted By CJ_London
Re: Records in combo box catch22

the issue you have is with your discontinued field - there are only two options - either it is discontinued or it isn't. Generally speaking it is not a good basis for a field

better instead to...
Forum: Modules & VBA 03-14-2019, 04:27 PM
Replies: 5
Views: 102
Posted By CJ_London
Re: How to Set a combo Box's Row Source To A SQL Server Source?

trust me, it has a recordset property, just try it. Not all properties are displayed in the property sheet
Forum: Modules & VBA 03-14-2019, 04:09 PM
Replies: 5
Views: 102
Posted By CJ_London
Re: How to Set a combo Box's Row Source To A SQL Server Source?

how are you reading the data from table? - if into a recordset, just assign the recordset to the combo

set rst=however you get your records
set mycombo.recordset=rst
Forum: Modules & VBA 03-14-2019, 11:48 AM
Replies: 7
Views: 105
Posted By CJ_London
Re: Double Click event not triggering After Update event

populating a control using vba does not trigger the after update event. Suggest you add to the code you posted


Private Sub FldRetireDate_DblClick(Cancel As Integer)

FldRetireDate =...
Forum: Forms 03-13-2019, 03:37 PM
Replies: 1
Views: 64
Posted By CJ_London
Re: Select all the frame and update

assuming coding is identical for each control, create a public function in a module for the code.

Then on your form, select all the frames and in the properties window (events) put
...
Forum: General 03-11-2019, 04:13 PM
Replies: 5
Views: 122
Posted By CJ_London
Re: Retrieving a Value

rowsource for your combo is presumably something like this


SELECT tblSalesPeople.ID, tblSalesPeople.SalesName, tblSalesPeople.Region
FROM tblSalesPeople
Modify to something like


SELECT...
Forum: General 03-11-2019, 03:33 PM
Replies: 5
Views: 122
Posted By CJ_London
Re: Retrieving a Value

easiest way is to include your manager table in the rowsource to your combo and bring through the code as an additional column
Forum: SQL Server 03-10-2019, 11:51 AM
Replies: 2
Views: 90
Posted By CJ_London
Re: Select Sum

don't understand the question since your sql will return just one value. but you could use

Me.txtResult =rsCable!SumAvMeter

or don't bother with a recordset, just use the dsum function
...
Forum: Forms 03-10-2019, 03:48 AM
Replies: 10
Views: 252
Posted By CJ_London
Re: Error Copying Field Data use =Sum([])

your transactionquantity is in a subform, you need to put your control in the header of footer of the subform.

however you already have that calculation in a control called SharesOwned, so refer...
Forum: Queries 03-09-2019, 01:57 PM
Replies: 2
Views: 95
Posted By CJ_London
Re: Save VBA Where Statement in Querydef

you need to concatenate the strings together

Q.SQL = "Select * From qryLaboratoryRecordList Where " & strWhere
Forum: Modules & VBA 03-06-2019, 04:21 AM
Replies: 4
Views: 100
Posted By CJ_London
Re: Get ID of created record overflow problem

pretty sure the OrgPosID will not be properly populated until after the .Update

have you tried

debug.print !OrgPosID

before assigning to intNewID?

Also suspect ADO behaves differently...
Forum: Queries 03-04-2019, 12:32 PM
Replies: 14
Views: 174
Posted By CJ_London
Re: Rich Text color problem for drop down menu

agreed, won't work with dropdown.
Forum: Queries 03-04-2019, 11:29 AM
Replies: 14
Views: 174
Posted By CJ_London
Re: Rich Text color problem for drop down menu

you can try using the format property but you would have to base it on just 3 values of -1, 0 and 1

e.g.

"No Action";[Red]"Action";"Urgent"

positive;negative;zero;null
Forum: General 03-04-2019, 07:57 AM
Replies: 15
Views: 748
Posted By CJ_London
Re: Access without network server

you know the path to the folder where the master FE is located. So the first bit of code run checks the currentdb.path against this if the same, it exits the app, perhaps with a message 'cannot be...
Forum: Hardware Questions and Answers 03-02-2019, 11:22 AM
Replies: 21
Views: 350
Posted By CJ_London
Re: Hum Hum Hum!

Unfortunately when I need to type something on the keyboard I need both hands!
sock off, foot on casing?
Forum: Queries 02-24-2019, 11:50 AM
Replies: 8
Views: 154
Posted By CJ_London
Re: make tables the same

you may also need extra queries where same ID but different field values - they will require an update query, but you need to decide which is the correct value
Forum: Forms 02-23-2019, 08:50 AM
Replies: 3
Views: 95
Posted By CJ_London
Re: Sort a Listbox on a Form

No, not possible - best you could do is modify the rowsource

myListbox.rowsource="SELECT * FROM SearchQ ORDER BY City"

but this will effectively re execute SearchQ - and assumes that City is...
Forum: Tables 02-23-2019, 04:56 AM
Replies: 11
Views: 240
Posted By CJ_London
Re: Import queries and UPEND operation

there are three methods of searching

find - where a searchvalue is found in an existing recordset - but still displays all records
filter - where a recordset is reduced to display just the...
Forum: Tables 02-22-2019, 05:43 AM
Replies: 11
Views: 240
Posted By CJ_London
Re: Import queries and UPEND operation

it really depends on how many records are in the temp table and how complex the query is to update the destination tables.

Appending data to an indexed temp table will be noticeably slower for a...
Forum: Queries 02-22-2019, 04:57 AM
Replies: 2
Views: 89
Posted By CJ_London
Re: Query not finding valid records

because you are passing a datetime value [Created On] to a dlookup as a string, you need to format it as mm/dd/yyyy. At the moment, 10/03 is being interpreted as 3rd Oct - which is later than 19th...
Forum: General 02-21-2019, 02:48 PM
Replies: 14
Views: 285
Posted By CJ_London
Re: Syntax Error 3075 - works on one form but not the other!

responders are not keen to go to other sites to download stuff - particularly from new users.

you need to remove from your db all tables/forms etc which are not relevant to your question, from...
Forum: Modules & VBA 02-21-2019, 12:35 AM
Replies: 51
Views: 825
Posted By CJ_London
Re: Retrieve SQL Results

Following in from docs comments - is the name choose control a list or combo box? If so is the field the row source is based on coming from a field in a table formatted as a lookup? If so then that...
Forum: Modules & VBA 02-20-2019, 09:58 AM
Replies: 23
Views: 373
Posted By CJ_London
Re: Make code Shorter

there is an assumption that your original 'long' code works - does it? and if not what error do you get? And what error are you getting with my suggestion?

I ask because normally you would use...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 02:58 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World