Search results

Ahhhh However, some of my subforms have data that is handled separately from its parent data... For instance... I have the following... tbl_Bank tbl_BankBranch tbl_BankEmployees Each table has a linked field to the one above it... So Employees are linked to Branches... So Branches are...

Yes and No See, I am glad that someone agrees with some of what I said... I guess I didn't clarify... Since my function runs the following whenever someone hits the delete buttons... DelCurRec: deleteQuestion = MsgBox("Are you sure you want to delete the current " & curForm.Tag & "?"...

I am working on a database where there will be a few people using it... I have already built forms where the users will interact with the data... I have added buttons that allow the user to add new records and delete them as well... All my buttons use the following code, this way I can...

NEVER MIND! Got it all worked out... See, I store the RowSource for my Listboxes in their Tag as a string... The purpose being too convoluted to go into on one post... Anyway, for EVERY listbox on ALL my forms, I have ONE function that runs them... For almost every form, I have one function for...

What?! Post what code? In order for me to post everything that relates up to and including the Final Function, I would have several pages of explanations... so, for simplicity sakes this will have to do... Public Function checkSQL(strSQL As String) ' This is why your question doesn't make...

Hide Access Window Hide Access Window Reference Try that... Also, just a thought... If you do a search, usually you can find answers like this... Not nagging at ya, cause sometimes I forget to search first, but I learned about doing this from this board about two years ago... The link above...

Ok... I have a function that gets passed a string... The string contains SQL code... SELECT statements only... How do I count those records? Due to the nature of the SQL, sometimes it will return NO records... sometimes it will return 0... and for some reason it treats them as two different...

What is happening... Well, I fill in one or two fields, when I have like 4 that are required at the table level, and when I close, part of my Form Closing script runs DoCmd.Save acCmdSaveRecord So it is saving it, when it should be saying, Uh... You didn't fill in, this and this and this...

The Forms ARE Linked... The Problem is the LISTBOXES... The Listboxes are throwing the problems in... I found a workaround by removing the rowsource of the listboxes... performing the delete actions... reassigning the rowsources to the listboxes... but I ONLY do this for the MAIN FORM: frm_Bank...

Ok... So I have a form where the user input data... The fields that are REQUIRED (from the underlying table) are NOT geetting filled in... Due to system / coding constraints, I have a close button that saves everything... Since I have multiple forms just like this one, just for different...

Listboxes on sub/subforms give "ENTER PARAMETER VALUE" on delete from Main Form Ok... I have three tables... Table: tbl_Bank Table: tbl_Bank_Branch TAble: tbl_Bank_Employees They are linked as such... tbl_Bank:bnk_ID -linked to- tbl_Bank_Branch:bnk_ID tbl_Bank_Branch:brnch_ID -linked to-...

Ok... I should prolly preface this... I use a custom button manager I am in the middle of designing for all the databases I build... So... when I press the delete button, here is the function I call... Public Function btnBasics(curForm As Form, curButton As Label, Optional rqstdObj As Object)...

They are Linked Tables... The Tables they are built from are all linked together... Table: tbl_Bank <primary key>: bnk_ID <link field>: -none- Table: tbl_Bank_Branch <primary key>: brnch_ID <link field>: bnk_ID Table: tbl_Bank_Employees <primary key>: bnk_empl_ID <link field>: brnch_ID...

Ok... I have a BANK form... it holds bank data (bank name, address, etc.) It has a Branch Sub Form... This holds Branch location and contact information... "IT" has an Employee Sub Form... This holds Employee listing for that Bank... Each Form / Subform has a List Box. The Employee Subform...

Dim strTest As String, frmTest As Form strTest = "frm_MainEntryForm" ' This is the NAME of the form Set frmTest = Forms(strTest) This is just a quick example that MOCKS my actual problem... I can get the Form Name... even subforms within... But... whether I get the Form Name like: strTest =...

Dim mstrForm as Form Set mstrForm = Forms!CStr(curButton.Tag) The curButton is a label... The curButton.Tag = "popfrm_BankEntries" All I am trying to do is get the stupid mstrForm to equal the curButton.Tag... What am I doing wrong...? I could swear I have done this before... ARGH!

Ummm. I forgot to explain WHERE the error happens... The error happens at EVERY point where it tries to DoCmd.Close... I cannot close the form from inside the LostFocus event... All I want to do is close the form at that point...

Here is the error I am getting on a Form I created. This is the LostFocus event for a textbox on my Form. Private Sub Proj_Title_LostFocus() Dim strSQLCriteria As String, qry As String, Response As VbMsgBoxResult On Error GoTo Err_ProjTitle Select Case IsNull(Proj_Title) Case True: GoSub...

Ok... I have a form that is linked to a Projects table... This form jumps from Project to Project and lists out all the pertinent data... On this form, I have a LISTBOX named: lst_ProjectSearcher It has a rowsource of: SELECT [tbl_ProjectBasics].[Proj_ID], [tbl_ProjectBasics].[Proj_Num]...

I found this answer on a Newsgroup ------------------------------------------------------------ You can't easily get them back out as Gif's but you can export the Images as Bitmaps. You could then use a program like Paint Shop Pro to batch convert them to Gif's or whatever. I just batch...