Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.17 seconds.
Search: Posts Made By: hassanogaibi
Forum: Modules & VBA 06-28-2016, 09:42 PM
Replies: 2
Views: 295
Posted By path479
Re: Retrieve the query name for a report

Hi Cronk. Thank you for your advice. Yes you are right I should put in more details.

I have worked out the issue. The problem was that the reports!YourReportName.recordsource was invoked...
Forum: General 06-28-2016, 09:30 PM
Replies: 15
Views: 909
Posted By Olops
Re: Find nearest value in same field

Sabi ko na nga ba pinoy.. sir pano ba kita ma private message? Trial and error plang kc ako.. bka may follow-up question pa ko... maraming salamat po..
Forum: Modules & VBA 06-28-2016, 09:29 PM
Replies: 2
Views: 295
Posted By Cronk
Re: Retrieve the query name for a report

Firstly, if you are posting a question with the statement
"but it doesn't work",
it would be helpful to have a bit more detail about what happens or what error you get.

If the report is in print...
Forum: Modules & VBA 06-28-2016, 08:58 PM
Replies: 2
Views: 295
Posted By path479
Retrieve the query name for a report

Is it possible to retrieve the query name for a report?

I am trying to create a button in a report and when the button is click, it would provide the name of the query that is behind the report...
Forum: General 06-28-2016, 08:51 PM
Replies: 5
Views: 713
Posted By Uncle Gizmo
If your check boxes are laid out on a form then...

If your check boxes are laid out on a form then you might find the technique demonstrated in this video useful:-

https://youtu.be/7NJTtqCLhZc

I must apologize for the poor presentation quality...
Forum: Queries 06-28-2016, 08:40 PM
Replies: 19
Views: 686
Posted By sneuberg
Re: deleting duplicate records

On the other hand this may not help as the OP stated



If he gets the data with the duplicates already present I don't think this outer join method will help. Maybe the code I provided is the...
Forum: General 06-28-2016, 08:39 PM
Replies: 15
Views: 909
Posted By arnelgp
Forum: General 06-28-2016, 08:31 PM
Replies: 15
Views: 909
Posted By Olops
Re: Find nearest value in same field

Thank you very much arnelgp!!
Forum: Queries 06-28-2016, 08:05 PM
Replies: 19
Views: 686
Posted By sneuberg
Re: deleting duplicate records

I agree with Galaxiom about using an outer join but just so you know you don't have to add an additional field to have a composite index. Just create one from all of the fields as shown in the...
Forum: Queries 06-28-2016, 07:54 PM
Replies: 19
Views: 686
Posted By Galaxiom
Re: deleting duplicate records

The down side of turning off Warnings is that any other reasons for rejecting records (eg wrong datatype or overflow) will be missed.

Do explore the option of an Update query with a outer joins...
Forum: Tables 06-28-2016, 07:48 PM
Replies: 2
Views: 499
Posted By Galaxiom
Re: using one table for all forms of stock

I believe you are on the right track with combining into the one table.

The only comment I would make is the storing the "percentage" of the ingredient amounts to a normalization issue. It is...
Forum: Queries 06-28-2016, 07:46 PM
Replies: 19
Views: 686
Posted By clean32
Re: deleting duplicate records

ok got it

a table to paste into.

append query with a new field, ie f1&f2&f3 etc

same om table being pasted to but this field is ID no duplicates

ok simple just turn off warnings
Forum: Queries 06-28-2016, 07:37 PM
Replies: 9
Views: 3,455
Posted By arnelgp
Re: Running query in VBA with where condition

it would be better to create a query with a form parameter that will filter your records.
therefore when exporting it to excel will not be difficult.

to export to excel:
...
Forum: Forms 06-28-2016, 07:27 PM
Replies: 8
Views: 1,950
Posted By arnelgp
Re: navigation form / filter

it disappeared because you already had it opened, when you opened the navigation form.
Forum: General 06-28-2016, 07:18 PM
Replies: 15
Views: 909
Posted By Olops
Re: Find nearest value in same field

Input data

[Name] [Weight]
aaa 100
aaa 103
aaa 103
bbb 60
ccc 300
ddd 500
eee 210
Forum: General 06-28-2016, 07:05 PM
Replies: 5
Views: 713
Posted By sneuberg
Re: Automatically Calculate Percentage of Checkboxes Selected

Where are these checkboxes. If they are in continuous forms and are bound to a table then is might be just

DCount("*", "[table name with Yes/No Fields]", "[Yes/No Field Name] = True")
Forum: General 06-28-2016, 06:47 PM
Replies: 5
Views: 713
Posted By nick1408
Re: Automatically Calculate Percentage of Checkboxes Selected

I've worked out the conditional formatting bit. Just need to work out the checkboxes now.
Forum: Modules & VBA 06-28-2016, 06:03 PM
Replies: 3
Views: 337
Posted By Cronk
Re: Lock users from viewing tables

As I wrote before, don't show the Navigation panel. All data input should be via forms. You can develop your own customized ribbon to open particular forms and reports (requires some coding) or use...
Forum: Modules & VBA 06-28-2016, 06:03 PM
Replies: 3
Views: 408
Posted By warlord
Re: VBA Code Assistance Requested

Which lines gives you a null error? Is it that your combo only has 2 columns, column(0) and column(1)

If OvalDegree <> 0 Then
'Calculate Oval Sin/Cos
Refresh
rs.Edit ...
Forum: Tables 06-28-2016, 05:22 PM
Replies: 2
Views: 499
Posted By Cowboy_BeBa
using one table for all forms of stock

hi all

i think ive pretty much figured this out, however id like a little bit of input from people with more experience than I have in database design
In our company we have several different...
Forum: Modules & VBA 06-28-2016, 04:58 PM
Replies: 3
Views: 337
Posted By Jennesa
Re: Lock users from viewing tables

I would but the problem is actually that my users are not savvy at all. The owner would still need to see the navigation pane but our office assistants wouldn't. If there is a way that I can put in a...
Forum: Modules & VBA 06-28-2016, 04:51 PM
Replies: 5
Views: 602
Posted By GreenWinter
Re: Cannot OpenRecordset on back-end database

Yes. The query I used is to add fields to the table which I think cannot be implemented from FE. So I wanted to alter the BE table directly. I'm a beginner in ACCESS. Please point out if anything...
Forum: Reports 06-28-2016, 04:48 PM
Replies: 0
Views: 300
Posted By Cowboy_BeBa
forcing X pages on a report

Hi all

Ive got a report im currently fiddling with

Basically its a report based on two tables
tblProduction (which is a list of all stock our company is producing in a given month)
and...
Forum: Modules & VBA 06-28-2016, 04:42 PM
Replies: 3
Views: 337
Posted By Cronk
Re: Lock users from viewing tables

Depends on how Access savvy your users are.

For most of my applications, I just hide the navigator window and apply access levels to which forms can be opened or editted.

Otherwise you can...
Forum: General 06-28-2016, 04:35 PM
Replies: 4
Views: 497
Posted By kirkm
Re: Access 2003 problem

Thanks Guus Will try that next time. Don't think arnelgp knew what I meant.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 09:42 AM.


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