Stop Form Opening When No Data

Feb 20, 2006

Hi people. I'm having fun with this one. I want to open a form frmOldRec from a list on frmSelectOld, only if there is data. I'e tried code such as:
Private Sub Form_Load()

Dim rst As Recordset
Set rst = Me.RecordsetClone

If rst.RecordCount = 0 Then MsgBox "No Records logged in this service area"

DoCmd.Restore,

'close etc etc

End sub

But I haven't been successful.

As it stands it opens a blank form if there's no suitable record. How can I stop this happening please?

Cheers Barry

View Replies


ADVERTISEMENT

Stop Form From Opening When Query Is Blank

Dec 16, 2011

I have a button that opens a form based on a query, the query is filtered based on an input field. This works great except when the user typos what they put into the input field. Since the query pulls no records it just opens a blank form. I want it to not open the form and instead open a message box telling the user the data they entered is not valid and to try again.

View 1 Replies View Related

Stop User From Opening FE MDE File Twice

Oct 18, 2007

Is there a way to stop users from opening the front end file twice (stop from having two sessions of the same FE at the same time)?

I've been searching the forum and found this
http://www.access-programmers.co.uk/forums/archive/index.php/t-67724.html
but since im not using an .exe updater is not my case t.t

View 5 Replies View Related

Stop Access From Changing Format / Value Of Data Entered From A Form Into A Table

Oct 7, 2012

I have a database (split into front and backend). Users populate the table using a form on the front end. Recently, it has been pointed out that some of the data entered into one specific textbox is being changed on the table. The data entered is always has a minimum of a letter and number value i.e. "A1", "A2" etc. Upon examining the table, this has changed into numeric values i.e. "1291", "1061", "852"... etc. Looks like it is translating them into both 3 and 4 digit numerical values by the looks of things. Where more complex data is entered such as "2(A1, A2)" these seem unaffected.

The field is set to text, I have set no validation rule, format or input mask. Just can't see why access is changing these values. It seems to be translating them, but I can't see a pattern.

View 2 Replies View Related

Forms :: Opening A Form From Another Form Via Combo And Auto Loading Form Data?

Apr 14, 2015

I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.

The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.

The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.

View 9 Replies View Related

Restricting Certain Data When Opening A Form

Mar 24, 2006

What I have is a database that I am using for 3 different sites; NE, NCA, & SCA. What I want to do is have the form ONLY show information for the specific site that the Leader is a member of. I have a security table that contains the persons name, & site location. For example: John Smith works at the NE site; so when he goes to open a form to add/modify/delete members from his site I want him to only be able to see date for NE from the table. So in the listbox NCA & SCA would be filtered.

How can I go about doing this? The forms Record Source is set to the Security Table. Please help so I can do this without having to create a seperate form for each different location. :)

View 3 Replies View Related

Preventing Opening A Form Unless Data Is Entered? And Some Other Q's.

Oct 29, 2006

Hello again,

I have three questions this time 'round:

1. I'm in need of some way of preventing a user from opening form B unless he has entered information in form A.

Right now it is possible to open form B without entering data in form A (form A being the date/time info and form B being the case technical info) due to which a record is created for clientnr 0 (which should be a non existing client). Querying for clientnr 0 from time to time and deleting those records is easy enough, but who knows what kind of relevant data could be stored accidentally in a record that doesn't belong there.

This happens by the way, even though referential integrity is enforced throughout the dbase. Maybe I should say, because of that. I want to keep it that way of course to prevent orphans roaming around. But having orphans for clientnr. 0 is also not a good idea.


2. What is the wiser thing to do: keep all information concerning one case for one client (date/time info per case, techinfo per case, maybe even products sold info per case, payment info per case) in one table and have the data needed for each thing entered in seperate forms, or have all data split up into seperate tables like I have now. One for clients, one for dates and times, one for the technical info for that case etc.... ?

It is starting to seem a bit ehrm... useless to have all that data for one case floating around seperate tables. I don't know... it seems so much more complex (having to create multiple relations, multiple PK's per table etc.).

Where do I draw the line? For example the image attached (relationship2.jpg): now I have one PK in the table holding the clients (clientnr), two PK's in the table holding the case date/time info (clientnr and casenumberdatetimeinfo), three PK's in the table holding the techinfo (clientnr, casenumberdatetimeinfo and casetechinfonr). And what's next? Four PK's in the table holding the sold productsinfo? Five PK's in the table holding the invoice info? And what about the relations between those tables? Right now I can still comprehend.... but when I start thinking ahead, I'm starting to get dizzy. So some advice on this would really be highly appreciated.

3. Which build up of the relations between the tables in the dbase is better? The one in relationship.jpg or the one in relationship2.jpg?

View 8 Replies View Related

Modules & VBA :: Opening New Form And Taking Data From Another

Jul 19, 2013

IThe db has a form called ClientFormNew which logs client details into a table called Clients.Each client has a unique client ID in the table called ClientID. Sometimes Clients call back for further information and we want to log that information into a related table called ClientHistory.Each record in the ClientHistory table has a unique ID called HistoryID which is the same number as the ClientID so these fields are related.

When a client calls back and the telephone adviser opens up the ClientFormNew form and discovers they have called before they need to click on a button called Client History which then opens up the ClientHistoryForm..I am struggling with the code to put on the Client History button as I want the new form to display the details of the clients first contact then allow details of the second contact to be added in a new row. Also the new form needs to show all that client past history which would be in the form of the following fields from the ClientHistory table.HistoryID, ContactDate, Name, ContactMethod, ContactReason, AdviceGiven, Notes.

View 2 Replies View Related

Forms :: Opening A Form To Enter New Data Only

Jun 7, 2014

I have been having problems with opening a form to add new records only. I have gone through all possible solutions but somehow the problem persists.I want to add new records only and not view any of the existing records. I have set the form properties to Date Entry Yes, Allow additions to Yes, Allow Edits to No. The form opens through a command button on another form and the vba code is the following.

DoCmd.OpenForm "FormInvDetails", acNormal, , , , acDialog

View 14 Replies View Related

Forms :: Get A Form To Requery Data Specified Prior To Opening

Jul 21, 2013

I have a main form "FrmTimesheetEdit" that I open in edit mode to review data in a query that uses two tables TblEmployee and TblTimeSheet. The TblEmployee has two fields called EmployeeID, and Employee. The Tbltimesheet table has a field "Weekendingdate" and "EmployeeID".Prior to loading the mainform I launch a form "frmEmployeeReportRange" that allows me to specify via combo box the Employee I am interested in and also the time periods I am interested in being "Beginningdate" and "EndingDate" These in turn are criteria for my query that supplies data to the main form "FrmTimesheetEdit" Everything seems to work ok.

However the first time I open the main form It open a form/window saying "Enter parameter Value" for EmployeeId, BeginningDate and Ending date respectively. Then the subform loads "frmEmployeeReportRange" which allows me to specify Employee plus beginning and ending dates. I select Employee from the combo box say "Emp1" and specify Beginning and Ending dates of 1-Jun-2013 and 30-Jun-2013. I then make the form invisible and the mainform opens up.I do this but get no records. If I close the main form "FrmTimesheetEdit" and reopen it the subform pops up as expected. It is preloaded with the data I entered the first time i.e. Emp1 plus 1-Jun-2013 and 30-Jun-13...If I leave the dates the same but select the next employee "Emp2" and them make the form invisible the mainform opens in edit mode as expected but with the records and dates specified for Emp1.

Bottom line it would appear that although the filter data is specified for the query that feeds the main form it is not requerying prior to opening the form. I have tried having the "frmEmployeeReportRange" launched as a VBA event on each of 'On Open' , 'On Load' and 'On Current' but no matter where I put it the results are the same in that the mainform is not requerying the data prior to opening.

View 5 Replies View Related

Forms :: Stock Inventory - Opening Form And Passing Data

Jan 9, 2014

I have a form that displays a stock inventory, one of the fields I use is called [ItemCode].

On the Stock_Inventory form I have 10 command buttons that open other forms to display additional product information.

These were previously sub_forms that sat in a tabbed control box within the Stock_Inventory Form but as it now takes a while for the form to load (lots of queries running each time you search for a product) users are getting slightly frustrated.

So, what I decided to do, was move each subform from the tabbed control into a new form and open that form when it is needed by the user.

OK, when I open Stock_Inventory and search for a product [ItemCode = "ABC123"] and then want to see the Sales_History, I have to open my new form, Stock_Inventory_Sales_History, within this form are two sub-forms, each subform has a field called [ItemCode].

However, when Stock_Inventory_Sales_History opens it asks me to input the parameter [ItemCode] twice, I presume this is because the Stock_Inventory_Sales_History does not have a record source and that the subforms need [ItemCode="ABC123"] to run each query and return the data.

I need to pass the [ItemCode] from the Stock_Inventory form to each of the 2 Subforms that are on the Stock_Inventory_Sales_History form automatically.

View 4 Replies View Related

Forms :: Closing Opening Form With Timer Then Opening Main Menu

Apr 7, 2014

I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.

Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub

Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.

View 5 Replies View Related

Stop Macro So I Can Input Data

Mar 27, 2006

I have a form that sets criteria in a series of make-table queries that go on to power a report. I've set up a macro to first open the form and then run the make-table queries and then open the final report. My trouble is that before I can set the criteria in the form I'm getting prompted by the make-table queries.

How can I stop the macro so I can input data and then re-start it? I tried using a stop macro command but that didn't work out for me.

Thanks

View 5 Replies View Related

How To Stop Duplication Of Data In Building Multiforms

Feb 26, 2008

I am a newbie. I am building mutiple tables/queries in one form. I got it to work but it is duplicating records where a name appears more than once. How can I stop this.

Regards

View 1 Replies View Related

Stop Access From Changing Data Importing Through VB6

Sep 11, 2011

I have an Access 2000 database in which i am importing some data programmatically through VB6. However for some reason Access is changing the data that i am sending it (i know it's access doing it as a manual import does the same thing)

Example data (dashes signify different columns 4 total)

8/31/11 - 08:30:45 - 1 - 003

this gets changed by access to

8/31/11 - 8:30:45 AM - 1 - 3

Note it changed the time to am/pm format and my 003 became 3 . I have all the database fields set as TEXT and not numbers / date & time so I would think that it would treat the data literally however that is not the case and my data gets messed up.

How do i tell access to stop messing with the data and treat it literally and not change anything ?

View 5 Replies View Related

Modules & VBA :: Stop Macro Error If There Is No Data To Find?

Jul 16, 2015

I completed the Op[en form and find specific data wizard and it works.

Here is my issue: If there is no data to find, I get a "Stop Macro" error.

How to change this?

View 1 Replies View Related

Forms :: Stop Access From Creating New Record When Inputting Data In Field Or Tab

Dec 17, 2013

How do you prevent access from adding a new record when u input data in the current record or tab to the next field? My database is set up to open with a form where the user picks his name and then a week ending date once that is complete u open a new form where the name and date auto populate along with other fields to fill out such as job charge, charge type , times charged for each day of the week. But I don't want access to create a new record everytime the person inputs or tabs..... .

I have attached my database for better clarity!

View 9 Replies View Related

Forms :: Stop User From Leaving Field Without Selecting Item / Entering Data?

Aug 29, 2013

how to stop user from leaving field without selecting item or entering data

View 2 Replies View Related

Stop Closing Form

Jul 25, 2007

Hi,
How can I stop user from closing the form if the mantory fields are not filled up? I try using gotocontrol but it is not working.

View 1 Replies View Related

Help To Stop Bypassing A Sub Form...

Nov 18, 2005

Hi I've been having this same problem for a while and I've had a bit of help here but none of the suggestions have so far worked.

Basically I need a way to stop people tabing through a sub form without entering data. The sub form has a check box that has to be checked (it can't be set as True as default) the required field doesn't work and for some reason the Enforce Referential Integrity on the join between the main table (tblCustInfo) and this one doesn't work either.

tblCustInfo = the main form
tblAgentData = subform

can anyone please help?

View 1 Replies View Related

Stop Form Going To New Record

Jun 27, 2006

i wonder if anyone can help with this problem i cant seem to work out.

i have a bound form linked to an orders table, including some required fields. when i use the navigation buttons of the form to scroll thorugh the orders i can get to the end where the form expects you to make a new order. but i have a button to add a new order.

i want to stop the user being able to go past the last record in the orders table. or enable them to get back to the last order. currently if the user goes past the last record (making a new order) there is no way to get back to the last record. using the navigation back button causes errors as the required fields are blank and access tries to save the order, thinking i want to make a new one.

i hope this makes sense.

i have tried setting the Allow Additions setting of the Form to No. but this causes problems when there is no data in the orders table. opening the form produces a blank form, showing no fields or buttons at all.

i would be greatful for any advice, maybe i am doing something fundamentally wrong?:confused:

View 5 Replies View Related

Stop Form Going To New Record

Jun 27, 2006

i wonder if anyone can help with this problem i cant seem to work out.

i have a bound form linked to an orders table, including some required fields. when i use the navigation buttons of the form to scroll thorugh the orders i can get to the end where the form expects you to make a new order. but i have a button to add a new order.

i want to stop the user being able to go past the last record in the orders table. or enable them to get back to the last order. currently if the user goes past the last record (making a new order) there is no way to get back to the last record. using the navigation back button causes errors as the required fields are blank and access tries to save the order, thinking i want to make a new one.

i hope this makes sense.

i have tried setting the Allow Additions setting of the Form to No. but this causes problems when there is no data in the orders table. opening the form produces a blank form, showing no fields or buttons at all.

i would be greatful for any advice, maybe i am doing something fundamentally wrong?:confused:

View 2 Replies View Related

How To Stop Form Openiing In Different Windows??

Sep 12, 2006

Hi there everyone,
Must be a really simple one, this one but can't seem to find the solution! :o

Can someone put me out of my missery and tell me how to make each form open in the same window instead of ending up with millions of open windows??!!
Thanks, Matt

View 6 Replies View Related

Stop A Form Being Moved By User

Feb 20, 2005

Is there anyway to stop the user from beng able to move a form. I.e. as in change its position on screen.

I am aware that you can do this by setting the border type to "none". However, I want my form to have a title bar along the top, so I cant use this method.

Is there another way to do this?

Thanks in advance.

EDIT: Ive found some information on the "movable" property, but I am using access 2000 and cant get it to work.

View 7 Replies View Related

Tab Stop Problem On Tabbed Form

Mar 30, 2006

Hi
I have set up a tabbed form to preview data going onto a report. There are four sub forms each on its own tab. I have locked down the data on the sub forms.
However when I open up the tabbed form the focus seems to shift to the first control on the tab. Ideally I want all the data controls on the tab to remain without focus leaving only the tab controls and the close form control that can get a focus.
Is there any way I can do this, or am I not making myself clear?
It isn't a deal breaker but it makes the form look a tad ugly!
Thanks for any help.

View 2 Replies View Related

Stop Macro On Last Record In Form

Dec 4, 2012

I have a macro that opens up a form called SLA Complete Form - The macro then goes and examines two fields on the form to see if they contain data and if they do not then it displays a popup box with a message.

The form that gets opened up can have anywhere from one record to approximately a hundred records.

How can I get the macro to stop running when it hits the last record on the form without displaying an error message. I am currently using the next record feature in the macro.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved