Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 36
Search took 0.02 seconds.
Search: Posts Made By: Cubsm22p
Forum: Gadgets 04-10-2019, 08:46 AM
Replies: 5
Views: 4,845
Posted By Cubsm22p
Re: WiFi repeater

The primary drawback of a wireless repeater is that it effectively halves the bandwidth for any computers connecting to it, rather than the primary router. The reason for this is that the repeater...
Forum: Reports 04-03-2019, 05:37 AM
Replies: 2
Views: 168
Posted By Cubsm22p
Sum on a report

I have some fields on my report that get totaled in the date footer, but i want to have a grand total at the bottom of the page is this possible.
74515
74516
Forum: Forms 03-29-2019, 08:40 AM
Replies: 16
Views: 282
Posted By Cubsm22p
Re: Help with tables In a Form

Thank You for all of your help
Forum: Forms 03-29-2019, 08:17 AM
Replies: 16
Views: 282
Posted By Cubsm22p
Re: Help with tables In a Form

That worked!, Lets say I want the search box to filter other other attributes along with the contentNum
Forum: Forms 03-29-2019, 08:09 AM
Replies: 16
Views: 282
Posted By Cubsm22p
Re: Help with tables In a Form

syntax error when i do it like this:
Me.Trackertbl_subform1.Form.Filter = "[ContentNum]='" & Me.Text2* & "'"
Me.Trackertbl_subform1.Form.FilterOn = True
Forum: Forms 03-29-2019, 07:55 AM
Replies: 16
Views: 282
Posted By Cubsm22p
Re: Help with tables In a Form

I put this in the 'after click update' on the search button and it worked:

Me.Trackertbl_subform1.Form.Filter = "[ContentNum]='" & Me.Text2 & "'"
Me.Trackertbl_subform1.Form.FilterOn = True
...
Forum: Forms 03-29-2019, 07:38 AM
Replies: 16
Views: 282
Posted By Cubsm22p
Re: Help with tables In a Form

Would I put that in the 'after update event' for the search box,
74447
Forum: Forms 03-28-2019, 01:21 PM
Replies: 16
Views: 282
Posted By Cubsm22p
Re: Help with tables In a Form

Now i would like to use this search button to put what ever i search on top of the list in the table.
74438
Forum: Forms 03-28-2019, 01:11 PM
Replies: 16
Views: 282
Posted By Cubsm22p
Re: Help with tables In a Form

like this:
74436

update got this error with that:
74437

Got it with this:
DoCmd.OpenForm "NewErrorfrm", acNormal, , "[ContentNum] = '" & Me![ContentNum] & "'"

Thanks for the help
Forum: Forms 03-28-2019, 12:47 PM
Replies: 16
Views: 282
Posted By Cubsm22p
Help with tables In a Form

74433

I would like to be able to click on these sub form records and have it open up a Editing_record form with the record that was clicked showing.

Editing_record form:74434
Forum: Reports 03-28-2019, 12:01 PM
Replies: 11
Views: 242
Posted By Cubsm22p
Re: Sum of a Report

Works Great thanks
Forum: Reports 03-28-2019, 11:41 AM
Replies: 11
Views: 242
Posted By Cubsm22p
Re: Sum of a Report

=Sum(IIf([Job Type]="JL" or "JLS",1,0))

something like that
Forum: Reports 03-28-2019, 11:35 AM
Replies: 11
Views: 242
Posted By Cubsm22p
Re: Sum of a Report

Thanks that works , how would i count the total if i want 'JL' and 'JLS' totaled.
Forum: Reports 03-28-2019, 11:24 AM
Replies: 11
Views: 242
Posted By Cubsm22p
Re: Sum of a Report

74431
74432

But i want to just count the records with [Job Type] 'JL' not all the the records
Forum: Reports 03-28-2019, 11:13 AM
Replies: 11
Views: 242
Posted By Cubsm22p
Re: Sum of a Report

What would i put as a field name in After the IF True statement i just want to count all the JL in that row in the report


=Count(IF([Job Type]="JL"),COUNT,DoNothing)
Or
=IF([Job...
Forum: Reports 03-28-2019, 10:44 AM
Replies: 11
Views: 242
Posted By Cubsm22p
Sum of a Report

I would like to count just the total of 'JL' in each row. right now i can only to get it to sum the total. Any help would be appreciated.
7442974430
Forum: Other Software 03-21-2019, 11:50 AM
Replies: 6
Views: 447
Posted By Cubsm22p
Re: Connecting to a Google Sheet

I would recommend exporting all your access tables to excel spreadsheets. Then from there you can import those excel spreadsheets into Google spreadsheets.

Good luck,
Forum: Reports 03-14-2019, 12:16 PM
Replies: 9
Views: 178
Posted By Cubsm22p
Re: Form is passing a '0" to Report when combo box is left blank on form

do the three fields that are doing this all have the same field type
Forum: Reports 03-14-2019, 11:52 AM
Replies: 9
Views: 178
Posted By Cubsm22p
Re: Form is passing a '0" to Report when combo box is left blank on form

I would recommend trying to set a default for those fields in the form as a space (" "):go to property box and set a default
74299
Forum: Modules & VBA 03-07-2019, 07:17 AM
Replies: 12
Views: 278
Posted By Cubsm22p
Re: Library book checkout form

Got it to Function properly using
Private Sub Command47_Click()
Dim strSQL As String

If DLookup("NumOfCopys", "Books1", "ISBN = Forms![CheckOutMenu]![ISBN]") = 0 Then
MsgBox "Book is...
Forum: Modules & VBA 03-07-2019, 06:47 AM
Replies: 12
Views: 278
Posted By Cubsm22p
Re: Library book checkout form

74213



I tested it more and I cant get the IF statement to run : It always jumps to the ELSE



updated code still not working:
Private Sub Command47_Click()
Forum: Modules & VBA 03-06-2019, 05:46 PM
Replies: 12
Views: 278
Posted By Cubsm22p
Re: Library book checkout form

Yea i got it to work using this:
74212

But now i would like to add IF Books1.[NumOfCopys] == 0 then error cant check out!


Thanks
Forum: Modules & VBA 03-06-2019, 05:16 PM
Replies: 12
Views: 278
Posted By Cubsm22p
Re: Library book checkout form

Here is What i have for a guess on the last issue
74211
Forum: Modules & VBA 03-06-2019, 04:20 PM
Replies: 12
Views: 278
Posted By Cubsm22p
Re: Library book checkout form

I got it to add a record to the Archive table when I click ok and my record source on the form is the Archive table.

I would like it to take away one book copy from the Books1 table with the...
Forum: Modules & VBA 03-06-2019, 09:48 AM
Replies: 12
Views: 278
Posted By Cubsm22p
Re: Library book checkout form

So basically when user enters ISBN and UserName Then once they click ok I want it to put a record in the Archive table With the ISBN and the UserName the user entered and also the Date
Showing results 1 to 25 of 36

 
Forum Jump



All times are GMT -8. The time now is 10:48 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