Openning A Form In Add Mode
Hi All,
This is such a newbie question I realise, but I have a form (frmFOBEntry) with a combobox (cboMarketCode) which returns a list from tblMarketCode.
New records are added to tblMarketCode using a form frmMarketCode
When I look through the combobox on the first form if the MarketCode I want is not there I want to be able to click a button which will open frmMarketCode in add mode.
Have looked through the forum and found all manner of flash ways to open on to certain records and the like, but nothing that simply opens the form so you can add a new record.
Also, if I add a record will the combobox update automatically?
Many thanks
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Openning A Database
Hi, I tried to open an Access database, (.mdb) supplied by a software vendor. When i open it, there is a message popping up saying "This database cannot be directly opened with Microsoft Access, pls use xxx software to view and edit". I believe this message is set by software vendor. When i click ok on this message, Microsoft Access just simply exit. In fact, if i just import this mdb to another mdb, i will be able to view or do editing there. My question is how is this message is set into the original database and is there a way to remove this message??
View Replies !
View Related
Maximized Form Changes To Restore Mode
:confused: I have a db app that has all forms maximized continually (I have set the vba code to do so on Open, Close and GotFocus events). From my app Home Page form the user can browse to other forms in the db. When another form is opened the window automaically maximizes. However, when the user navigates back to the Home Page it goes in restore mode. I haven't told it to do this anywhere. I have also tried saving the form stretched out to fit the full screen, so that if it goes into restore mode it at least still fills the screen, but it still reverts to a restored window (about half the screen). It doesn't matter what configuration I use in the AutoResize, AutoCenter properties either. I have been developing custom db apps in Access for over 8 years. However, this seems to be a stupid (albeit simple) problem that is annoying me. I currently use Access 2003 and this issue is new (or so I believe since I never ran into the problem in previous versions). Any ideas? Thanks...
View Replies !
View Related
Form Mode In Switchboard Question
Have a question on the switchboard choices I've always wondered about. Why are there only "Add" and "Edit" modes to open a form from the switchboard? I see many, many times when you want to allow a form to be opened in "readonly" mode to page through records but not allow edits or additions. Why does Access NOT have "Readonly" as an option?
View Replies !
View Related
Launching A Form In Datasheet Mode
I have a form designed in DS mode. If I open it directly (double click on it on the Panel), it works fine When opening it programmatically (from a button in another form) it shows just ONE record, in spite of having room enough for several records. May I get some help to check what am I doing wrong? thanks
View Replies !
View Related
Openning Word And Excel To Show Default Docs
I'm using this code which I think Came from a Button Wizard many moons ago but when I use it It opens the app for the function but does not display the default Blank Doc.Could anybody point me in the right direction for getting them to show the default blank DocsMany ThanksMickPrivate Sub CmdRunWord_Click()On Error GoTo Err_CmdRunWord_Click Dim oApp As Object Set oApp = CreateObject("Word.Application") oApp.Visible = True oApp.Caption = "Database Dreams - Word"Exit_CmdRunWord_Click: Exit SubErr_CmdRunWord_Click: MsgBox Err.Description Resume Exit_CmdRunWord_Click End SubPrivate Sub CmdRunExcel_Click()On Error GoTo Err_CmdRunExcel_Click Dim oApp As Object Set oApp = CreateObject("Excel.Application") oApp.Visible = True 'Only XL 97 supports UserControl Property On Error Resume Next oApp.UserControl = True oApp.Caption = "Database Dreams - Excel" Exit_CmdRunExcel_Click: Exit SubErr_CmdRunExcel_Click: MsgBox Err.Description Resume Exit_CmdRunExcel_Click End Sub
View Replies !
View Related
Form In Datasheet Mode : Name Of Textbox Is Caption Of Column ???
My form is in datasheet mode. One of the textbox is called txtHours When I access the form the column caption is "txtHours" ! As you can expect it looks ugly. So to get a decent caption like "Hours" I am forced to set my textbox name to "Hours" ! As you can expect it goes against my coding standard to do that. Beside I want the caption of some textboxes to include some non-standard letters such as `é' è' '!' ' ' etc. and if I put those in the textbox name it ruins the visual basic code !
View Replies !
View Related
Form Mode "Create" V. "Revise"
Is there a way I can tell if a form is in "Create" mode v. "Update" mode"? I want to send an email when a form is being Created, but not when a form is being Updated. Currently I'm sending an email everytime the form is saved...this is nonsense. Any help is appreciated.
View Replies !
View Related
Safe Mode
Hello all, Has anybody ever encountered this before. I can't seem to get rid of it. When logging in to my Acc 2003 db I get a message along the lines of... "Access failed to start correctly last time. Starting access in safe mode will help isolate a startup problem. Do you want to open in Safe Mode?" When selecting No, it allows me in as normal. This happens everytime I log in now. Even when choosing Yes then exiting the db. Anybody know where to start looking for the solution? Thanks Kempes
View Replies !
View Related
Mean Mode Help Required
Hi, I found a couple of short threads on the forum discussing the above. None of them go sufficiently far enough into detal to help me solve my (relatively simple) problem. My boss has asked me to produce both mean and mode calculations for the number of pallets we ship to our branches on the 30+ routes that we service. So far I have managed to implement mean but mode seems to have me stumped. I'm aware there actually isn't a mode function in Access as such but like mode, is there a way to calculate the most frequent occurrence of a number over a time period? My query is already producing Min, Max, Sum (and now mean) results for the pallets we ship, can someone offer me help on this? All the code that I have retrieved so far seems to be based on something similar to this: select top 1 with ties your_column from your_table group by your_column order by count(*) desc I have very little to no idea about how to implement this into my query. Any help would be appreciated. Thanks In Advance. sausagefingers
View Replies !
View Related
Subform In Add Mode?
I'm having a little trouble implementing this... help would be appreciated. Quite a novice with Access. I have a Client form. I have an "Add Mode", where your able to add new data to the form. This is all fine and dandy. However... The Client has a Shipping Address and a Billing Address. I was hoping of creating a tabular type of dataform; however I'm finding it hard to limit access to a finite number of records. Would this be easier to do with three seperate forms; first putting in the client information, then the billing address information and finally the shipping address information? If yes, how do I call a module?
View Replies !
View Related
Sub Works Only In Step Mode
It's been a while since I've been on the boards. Good to see lots of the same folks are still here. :D I've got an interesting problem. I have a sub that calls another sub. Pretty simple there. The problem is that when sub A calls sub B, sub B does not appear to run. This is all sub B does:If Not IsNull(Me.txtNumber) Then Me.txtNumber = Me.txtNumber + 1 End If The weird thing is, sub B runs just fine if I run the sub B in step mode. If I set a break point and use F8 to step through the code line-by-line, it runs just fine. If I take out the breakpoint, the code no longer works. Anybody have any ideas? I'm running Access XP Sp2 on Windows XP SP1. Thanks.
View Replies !
View Related
Msg Box On Close Only If In Edit Mode
I have a form that is locked unless they click the command button to edit records. I want a msg box that when they click the close button it pops up with something like save edits? Just as an extra precaution. But I only want the message box to pop up if the form is in edit mode. Is this possible? And I would like to be able to have them click ok or cancel in the message box Here is the code for the close button: Private Sub Close_Click() On Error GoTo Err_Close_Click DoCmd.Close Exit_Close_Click: Exit Sub Err_Close_Click: MsgBox Err.Description Resume Exit_Close_Click End Sub Thanks Tracy
View Replies !
View Related
|
TRACKER
