Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.12 seconds.
Search: Posts Made By: GinaWhipp
Forum: Reports 12-01-2017, 05:45 PM
Replies: 16
Views: 2,870
Posted By GinaWhipp
Re: Hide subreport on no data

AndrewS,

It's the little things! :D
Forum: General 07-03-2017, 09:00 PM
Replies: 4
Views: 389
Posted By GinaWhipp
Re: Open /View old Access Databases?

Yeah, Access 97 will not open in Access 2016, it needs to be 2000 at a minimum. Do you know anyone that has 2003 who can convert it for you? Other than that it is a problem.
Forum: General 07-03-2017, 08:57 PM
Replies: 1
Views: 323
Posted By GinaWhipp
Re: Can't see full search bar in access form

This is usually the result of your Display Settings sounds like yours is set above 100%. Adjust that and see if it fixes the problem.
Forum: Forms 05-11-2017, 02:42 PM
Replies: 18
Views: 644
Posted By GinaWhipp
Re: Requery a listbox in Main form but stay on current Record

Umm, that is not the code that runs the append queries or are you saying you're using a Macro?
Forum: Forms 05-11-2017, 10:53 AM
Replies: 18
Views: 644
Posted By GinaWhipp
Re: Requery a listbox in Main form but stay on current Record

Where's the code that runs the append query? We code move that last line there...
Forum: Forms 05-11-2017, 10:32 AM
Replies: 18
Views: 644
Posted By GinaWhipp
Re: Requery a listbox in Main form but stay on current Record

Okay, let's switch that around...


Dim lngPK As Long 'change data type if yours is different

'set variable to current record ID
lngPK = Me.SerNo
Me.Parent.ListOne.Requery
'Me.Requery...
Forum: Forms 05-11-2017, 09:30 AM
Replies: 18
Views: 644
Posted By GinaWhipp
Re: Requery a listbox in Main form but stay on current Record

Dim lngPK As Long 'change data type if yours is different

'set variable to current record ID
lngPK = Me.SerNo
Me.Parent.ListOne.Requery
Forms![MainFormName]![ListOne] = lngPK
'Me.Requery...
Forum: Forms 05-11-2017, 09:05 AM
Replies: 18
Views: 644
Posted By GinaWhipp
Re: Requery a listbox in Main form but stay on current Record

I need more coffee... sorry about that. Then I don't understand why the first line I gave you did not work. Is not lngPK equal to that of the List Box Primary Key?
Forum: Forms 05-11-2017, 08:25 AM
Replies: 18
Views: 644
Posted By GinaWhipp
Re: Requery a listbox in Main form but stay on current Record

Oh, I thought it was to bring the focus to the records you just appended. To stay on the current record use...


Dim intCurrentID As Integer

intCurrentID = Me.CurrentRecord
...
Forum: General 05-11-2017, 07:23 AM
Replies: 6
Views: 554
Posted By GinaWhipp
Re: 2nd running MsAccess Fast removal

But if there is an error your routine may stop prematurely leaving a Recordset open. Have you checked for that?
Forum: Forms 05-11-2017, 06:28 AM
Replies: 18
Views: 644
Posted By GinaWhipp
Re: Requery a listbox in Main form but stay on current Record

What is the Primary Key of the List Box? Is it the same as the one you are requerying?
Forum: Forms 05-10-2017, 02:25 PM
Replies: 18
Views: 644
Posted By GinaWhipp
Re: Requery a listbox in Main form but stay on current Record

Do you see your old line *Me.Parent.ListOne.Requery*? Just add that second line right under it...
Forum: Forms 05-10-2017, 01:36 PM
Replies: 18
Views: 644
Posted By GinaWhipp
Re: Requery a listbox in Main form but stay on current Record

Hmm, try...

Me.Parent.ListOne.Requery
Forms![MainFormName]![ListOne] = lngPK
Forum: General 05-10-2017, 08:07 AM
Replies: 16
Views: 859
Posted By GinaWhipp
Re: Problem with access database !!

Well, can't think of anything else to try... If you find a way to zip up the file and upload we could then give it another try.
Forum: General 05-09-2017, 08:18 AM
Replies: 16
Views: 859
Posted By GinaWhipp
Re: Problem with access database !!

Then those Forms have some sort of corruption. Have you tried exporting them one at a time AND can you open them in Design mode?
Forum: General 05-08-2017, 09:14 AM
Replies: 16
Views: 859
Posted By GinaWhipp
Re: Problem with access database !!

Hmm, okay let's try this... instead of trying to import all the Objects into a clean database open the existing database (hold the Shift Key down) and export the Objects out to a clean file. Do this...
Forum: General 05-07-2017, 10:26 PM
Replies: 16
Views: 859
Posted By GinaWhipp
Re: Problem with access database !!

Is it possible this database is 2 gig and not 2 mb? The reason I ask is the error you are getting suggest either that or corruption. And when was the last time you ran Compact & Repair?
Forum: General 05-07-2017, 10:12 PM
Replies: 6
Views: 554
Posted By GinaWhipp
Re: 2nd running MsAccess Fast removal

Sounds like you are not specifically closing a Recordset somewhere...
Forum: Modules & VBA 05-07-2017, 10:02 PM
Replies: 5
Views: 550
Posted By GinaWhipp
Re: VBA code for forgot password and change password in acce07

This should get you started...


If Me.cboAssociateID = "" Or IsNull(Me.cboAssociateID) Then
MsgBox "Please select your User Name first!", vbInformation + vbOKOnly, "User Name"
...
Forum: Forms 05-07-2017, 09:48 PM
Replies: 13
Views: 801
Posted By GinaWhipp
Re: Locking Certain Fields on a Form with a Table.

Perhaps this will help...


Function ImLocked(frm As Form, LockIt As Boolean) As Boolean
'Lock or unlock all data-bound controls on form,
'depending on the value of <LockIt>: True =...
Forum: Forms 04-25-2017, 12:31 PM
Replies: 18
Views: 15,187
Posted By GinaWhipp
Re: Open Form with current record

First I would make sure you don't have the Form set to open for Data Entry Only. If that is not it then try remming that out and see what happens.
Forum: Forms 04-25-2017, 09:29 AM
Replies: 18
Views: 15,187
Posted By GinaWhipp
Re: Open Form with current record

Oh, then no public variable, the below should work...

DoCmd.OpenForm "frmMOS_main", , , "[MOSID]=" & 5"
DoCmd.Close acForm, Me.Name
Forum: Forms 04-24-2017, 10:29 PM
Replies: 18
Views: 15,187
Posted By GinaWhipp
Re: Open Form with current record

Okay, I think you're going to want to use a Public Variable to get what you want. You can assign it at the log on form and then use it as a parameter to open the next Form thereby opening a specific...
Forum: General 04-24-2017, 12:00 PM
Replies: 6
Views: 611
Posted By GinaWhipp
Re: How to Create Custom Calendar

Hopefully, this will get you started on the collision part...
http://access-diva.com/blog/?p=397
Forum: Forms 04-24-2017, 11:27 AM
Replies: 18
Views: 15,187
Posted By GinaWhipp
Re: Open Form with current record

But your code is listing SAPID, where is it supposed to get the MOSID? That said if you always want it to open to number 5 then add that to criteria for the arguments for opening the Form.
Showing results 1 to 25 of 500

 
Forum Jump



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