Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.35 seconds.
Search: Posts Made By: llkhoutx
Forum: General 02-24-2018, 07:53 PM
Replies: 6
Views: 522
Posted By llkhoutx
Re: Office 2007 & 2010

No there isn't.
Forum: Forms 02-20-2018, 10:40 AM
Replies: 4
Views: 132
Posted By llkhoutx
Re: Bound form not saving data to table

Forms bound to queries can be problematic. Queries can be and are often non-updatable record sets.
Forum: Reports 02-04-2018, 12:37 PM
Replies: 5
Views: 414
Posted By llkhoutx
Re: Conditional page break question

Instead of using "Me," use Reports!YourReportname!YourControlName.
Forum: Modules & VBA 02-02-2018, 01:44 PM
Replies: 5
Views: 248
Posted By llkhoutx
Re: Finding Records with increased values

Queries can't compare values of adjacent rows.

Cycle through the table or query, row by row, with DAO or ADO code, comparing the current row against the previous row.
Forum: Queries 02-02-2018, 01:39 PM
Replies: 1
Views: 161
Posted By llkhoutx
Re: Criteria Problem?

The criteria must be concantenanted by a ", #, or nothing at all, depending on the datatype of the "cbo_cat." If cbo_cat is bound column of the combobox, i.e. column(0), Select the correct column,...
Forum: Queries 01-30-2018, 02:34 PM
Replies: 1
Views: 155
Posted By llkhoutx
Forum: Forms 01-23-2018, 02:05 PM
Replies: 2
Views: 176
Posted By llkhoutx
Re: Scrolling with Mouse Scroll Wheel

Click on the form, not a control on the form to scroll.
Forum: Reports 11-19-2017, 04:36 PM
Replies: 14
Views: 510
Posted By llkhoutx
Re: Cannot work out how to extend the layout to a new section

Subreports are quite common. If they are not properly linked to the main report, no data will be displayed.
Forum: Forms 11-19-2017, 04:34 PM
Replies: 14
Views: 557
Posted By llkhoutx
Re: Distribution of the amount

I would never open a posted database unless I knew the posted. Anyone that opens it is taking a significant risk.
Forum: Forms 11-19-2017, 04:31 PM
Replies: 3
Views: 208
Posted By llkhoutx
Re: Help with an expression

I think that any null value will kill your calculation.

To debug the calculation, put each iif component is a separate column in your (select) query and check for valid results. Each iif might...
Forum: Modules & VBA 11-07-2017, 11:37 AM
Replies: 1
Views: 274
Posted By llkhoutx
Re: Something Im Making to make it easier to copy different excel sheets to MS acces

It's not clear whether this code is in Excel or Access or exactly want you want to do.

I would use the Access command "TranmsferSpreadsheet" to import Excel data. It does all the work for you....
Forum: Modules & VBA 11-07-2017, 11:26 AM
Replies: 7
Views: 355
Posted By llkhoutx
Re: Export table data using FreeFile

Add a datestamp field to each table so a to be able to determine when a table has been updated. You may also want another datestamp field of when existing rows are updated.

Cycle through the...
Forum: Forms 11-07-2017, 11:19 AM
Replies: 2
Views: 245
Posted By llkhoutx
Re: Notes Form

Use an appropriate event to open the desired form with a subroutine. A button on the subform is probably appropriate because merely selecting a note is probably not what you want.
Forum: General 11-07-2017, 10:52 AM
Replies: 4
Views: 663
Posted By llkhoutx
Re: remove owner name in title

I think that this is controlled by Microsoft Access and the "ownership" of Access software being executed, not the front end.
Forum: Tables 11-06-2017, 01:43 PM
Replies: 2
Views: 486
Posted By llkhoutx
Re: update backend split table

Open the backend database and import the Excel sheet (menu External Data>Excel). Verify the name of the table and datatype of the the new table's columns. If the new table does not have a primaryt...
Forum: General 11-06-2017, 01:24 PM
Replies: 1
Views: 396
Posted By llkhoutx
Re: Access Printing options

A receipt is merely a report in Access. Your "receipt printer" is selected usin the orint option and the report is the correct paper size.
Forum: Forms 09-18-2017, 06:52 PM
Replies: 3
Views: 324
Posted By llkhoutx
Re: Form option group - single click selects 3 options

You option group is not correctly bouind to your form.
Forum: Queries 09-18-2017, 06:47 PM
Replies: 11
Views: 441
Posted By llkhoutx
Re: Query to subtract current stock from previous stock

As I understand your question, what you want is the difference between the next to last quantity for each product and the last quantity for each product.

You example assumes that there's always at...
Forum: Macros 09-08-2017, 01:57 PM
Replies: 1
Views: 802
Posted By llkhoutx
Re: Add new action combobox in new macro is empty

I've used Access, all versions, since Access first came out and have learned that there's a numbers of reasons to use Macros within Access. VBA coding is very simple, easy to learn, and very...
Forum: Forms 11-26-2016, 02:52 PM
Replies: 2
Views: 262
Posted By llkhoutx
Re: Filtering forms

Filter the form record source with the "status" combo box name. Note that the full form reference is required, not a Me reference, i.e. Forms!YourFormName!YourComboBoxName
Forum: Reports 08-22-2016, 06:41 AM
Replies: 9
Views: 774
Posted By llkhoutx
Re: Show-Hide Report Details linked to group header

I repeat, once the report is created it cannot be changed. Hiding or displaying something is a change.
Forum: Reports 08-19-2016, 09:28 AM
Replies: 9
Views: 774
Posted By llkhoutx
Re: Show-Hide Report Details linked to group header

Once a report is opened it cannot be modified. The only time a report can be modified is on the "OnFormat" event, that is, when it is being formatted (built). Buttons don't work on reports.
Forum: Forms 04-15-2016, 05:19 AM
Replies: 2
Views: 320
Posted By llkhoutx
Re: Can't close open hidden workbook

Thank you, I'll give you suggestion a try.
Forum: Forms 04-14-2016, 10:26 AM
Replies: 2
Views: 320
Posted By llkhoutx
Can't close open hidden workbook

I using Access 2010 (Enterprise) on Windows 7 Enterprise PC. In the course of executing VBA code, I open an Excel workbook in Access using

Dim xlAPP As Excel.Application
Dim wKb As...
Forum: Reports 02-26-2016, 12:39 PM
Replies: 0
Views: 452
Posted By llkhoutx
Close modified subreports & reopen Report

I have complex A13 reports each of which has multiple complex subreports whose various control properties are programmatically modified in the report's design view and then closed along with the...
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 08:18 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

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