Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.12 seconds.
Search: Posts Made By: llkhoutx
Forum: Tables 07-20-2018, 01:28 PM
Replies: 4
Views: 122
Posted By llkhoutx
Re: Count

Use the NZ function to conver Nulls to 0. if any.
Forum: Forms 03-27-2018, 10:24 AM
Replies: 10
Views: 315
Posted By llkhoutx
Re: Keep field in main form highlighted after focus is lost

Change/reset the control background color as approporiate.
Forum: General 02-24-2018, 07:53 PM
Replies: 6
Views: 598
Posted By llkhoutx
Re: Office 2007 & 2010

No there isn't.
Forum: Forms 02-20-2018, 10:40 AM
Replies: 4
Views: 192
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: 571
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: 371
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: 214
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: 211
Posted By llkhoutx
Forum: Forms 01-23-2018, 02:05 PM
Replies: 2
Views: 234
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: 577
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: 756
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: 283
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: 315
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: 455
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: 283
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: 799
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: 554
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: 442
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: 357
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: 489
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: 891
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: 277
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: 839
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: 839
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: 353
Posted By llkhoutx
Re: Can't close open hidden workbook

Thank you, I'll give you suggestion a try.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 12:26 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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