Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 48
Search took 0.02 seconds.
Search: Posts Made By: foxtet
Forum: Forms 06-21-2016, 12:30 AM
Replies: 4
Views: 381
Posted By arnelgp
Re: Highlight the entire row when mouse moves over the row

drag an unbound textbox on the detail section of your form.
delete its associated label control.
name the textbox txtHidden. set its Visible property to False.

on the current event of your form,...
Forum: Forms 06-19-2016, 12:42 PM
Replies: 4
Views: 749
Posted By sneuberg
Re: Double click continuous form to open another form

I've played with this and I can't seem to get it to distinguish one record from another. Since this is a different topic I suggest you start a new thread with a title that reflects your question...
Forum: Forms 06-19-2016, 11:20 AM
Replies: 4
Views: 749
Posted By sneuberg
Re: Double click continuous form to open another form

The code that will do this is:

DoCmd.OpenForm "frmEditContact", acNormal, , "[Sno] = " & Me.Sno, acFormEdit, acWindowNormal


But there doesn't seem to be one place where you can put it where...
Forum: Forms 06-12-2016, 07:44 AM
Replies: 8
Views: 555
Posted By arnelgp
Re: display save data on subform on another form

sorry for my previous post, here's the fix.
Forum: Forms 06-12-2016, 06:57 AM
Replies: 8
Views: 555
Posted By moke123
Re: display save data on subform on another form

why not use the not in list event?
Forum: Forms 06-12-2016, 06:44 AM
Replies: 8
Views: 555
Posted By arnelgp
Re: display save data on subform on another form

Private Sub Form_Close()
If CurrentProject.AllForms("tbl_Entity_Info").IsLoaded = True Then
Forms![tbl_Entity_Info]![tbl_Contact_Info subform].Form.Requery
End If
End Sub
Forum: Forms 06-12-2016, 02:30 AM
Replies: 8
Views: 555
Posted By moke123
Re: display save data on subform on another form

not to be off topic , but i would highly recommend you re-do your tables and drop the lookup fields in your tables. you should have lookup tables and store the primary keys in a foreign key field....
Forum: Reports 01-14-2016, 11:48 PM
Replies: 3
Views: 351
Posted By JHB
Re: Open correct report

How do you open the report, code or??
If code then show it.
Forum: Forms 01-08-2016, 12:42 AM
Replies: 2
Views: 685
Posted By arnelgp
Re: Cannot save as ACCDE

nice info, but which db are you compiling, accdb or mdb?
Forum: Forms 01-05-2016, 05:16 AM
Replies: 23
[SOLVED] sub form
Views: 1,066
Posted By Alvarogue
Re: sub form

Ok here it is. I hope this can work. Please let me know if you need more info, but as soon as you play with it, since is a small database you get it checked out in a couple of minutes ok?
Forum: Forms 01-04-2016, 10:22 PM
Replies: 6
Views: 631
Posted By arnelgp
Re: Hide text fields in subform

In your subforms Load Event:

Me.ID.ColumnHidden = True
Me.InvNo.ColumnHiddent=True
Forum: Forms 01-04-2016, 09:58 PM
Replies: 23
[SOLVED] sub form
Views: 1,066
Posted By JHB
Re: sub form

Could you post your database here in the forum, because I can't open file with the rar extension.
Do a "Compact & Repair" and then zit it.
Forum: Forms 01-04-2016, 12:32 PM
Replies: 23
[SOLVED] sub form
Views: 1,066
Posted By Alvarogue
Re: sub form

BTW, The trucks are located in a different form, so its a Form, from another Subform.
Forum: Forms 01-04-2016, 12:31 PM
Replies: 23
[SOLVED] sub form
Views: 1,066
Posted By Alvarogue
Re: sub form

Yeah, here:
http://www.megafileupload.com/inxN/4...chDatabase.rar

The problem I have is that my Navigation Form is working directly from a query, instead of the tables, and I did that because if...
Forum: Forms 01-04-2016, 12:10 PM
Replies: 6
Views: 631
Posted By llkhoutx
Re: Hide text fields in subform

Set the "Visible" property on the datasheet columns you with to hide to False or No. Visible, or not, those controls will be saved appropriately.
Forum: Forms 01-04-2016, 12:08 PM
Replies: 6
Views: 631
Posted By JHB
Forum: Forms 01-04-2016, 09:04 AM
Replies: 23
[SOLVED] sub form
Views: 1,066
Posted By JHB
Re: sub form

You're welcome, good luck.
Forum: Forms 01-04-2016, 05:22 AM
Replies: 23
[SOLVED] sub form
Views: 1,066
Posted By Alvarogue
Re: sub form

Hey JHB, are you knowledgeable in Relationships and subforms?? I have major problems with my database and I need some extra help to fix them up. I been researching without success.
Forum: Forms 01-03-2016, 10:01 PM
Replies: 23
[SOLVED] sub form
Views: 1,066
Posted By JHB
Re: sub form

Try the attached database, I've imported all into a new database, because what you attached had some problem.
Forum: Forms 01-03-2016, 08:38 AM
Replies: 23
[SOLVED] sub form
Views: 1,066
Posted By Alvarogue
Re: sub form

just like that??
Forum: Forms 12-30-2015, 07:17 AM
Replies: 6
Views: 595
Posted By arnelgp
Re: Auto fill in tab

please try this.
Forum: Forms 12-21-2015, 09:48 PM
Replies: 23
[SOLVED] sub form
Views: 1,066
Posted By JHB
Re: sub form

Put in an event there save the record and afterwards requery the form.
Forum: Forms 12-21-2015, 07:10 PM
Replies: 4
[SOLVED] Add to Combo Box
Views: 366
Posted By sneuberg
Re: Add to Combo Box

Maybe you want to requery the combo box from the frmFlight Save command button. If so you can add

Forms![frmAddNewCargo]![FlightID].Requery

to the cmdSaveFlight_Click as I have done in the...
Forum: Forms 12-13-2015, 06:40 AM
Replies: 4
Views: 570
Posted By arnelgp
Re: Added record not showing in navigation frm

my good friend you may try this. i hope nobody challenge me this time.
Forum: Forms 12-12-2015, 09:28 AM
Replies: 2
[SOLVED] Navigation form
Views: 507
Posted By Uncle Gizmo
Re: Navigation form

You've got this code:-

Option Compare Database
Option Explicit

Private Sub Form_Open(Cancel As Integer)
Call SecurityEnabled(Me.Name, "Form") ' enable security for this form
End Sub
...
Showing results 1 to 25 of 48

 
Forum Jump



All times are GMT -8. The time now is 03:24 PM.


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