Create Record With VBA, Edit With Form

Mar 11, 2008

I have the following code on a combo box in a form that creates a new record in the table Products if it doesn't already exist:

Code:Private Sub comProduct_NotInList(NewData As String, Response As Integer) Dim strSQL As String 'Exit this sub if the combo box is cleared If NewData = "" Then Exit Sub strSQL = "Insert Into Products ([Product]) " & _"values ('" & NewData & "');" CurrentDb.Execute strSQL, dbFailOnError Response = acDataErrAdded End Sub

It creates a new record and inputs the appropriate value into the Product field, however then it goes to the next record and when I try to edit other fields, it does so on a new record.

So, for example, I wanted to set the Product field to ProductA and the Brand field to BrandB and the Size field to 200, it produces two separate records like this (code box used for formatting):

Code:Product | Brand | Size |ProductA BrandB 200

View Replies


Forms :: How To Create A Form That Can Edit Or Create A Record

May 13, 2014

I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?

View 1 Replies View Related

General :: Create Duplicate Entry On A Table And Then Edit New Or Old Record

Sep 2, 2013

I am trying to create a duplicate of a certain record in a table so that the user can then edit the new record - or old record even as it doesn't matter - as long as one of them is original. The idea is that any revisions / changes are stored the user may of made.

View 2 Replies View Related

How Create Form That Allows You To Edit But Not Add New Records.

Mar 30, 2006

I guess this is a fairly basic one. I have a form that allows people to edit records, but I want to prevent people from adding new records on this form. I thought that if I put 'no' in the 'Allow additions' property, I would achieve this end, but when I do this, all the input boxes dissappear.
appreciate help

View 2 Replies View Related

Cant Create Image Edit Control In Access Form

Oct 4, 2006


I've searched a lot and couldn't find an answer to my problem.

I want to have a field in my form that allow me to paste an image from the clipboard to, for example, a Paint field. Then, I want to save that image to a file on a specific folder in my computer via VB.

The reason for this is that I don't want to ask the user to open paint by himself and save the file, probably in the wrong location and with the wrong name.

The first approach was creating an OLE Object directly from the Insert menu and that worked partially. It allowed me to paste the image but there wasn't a way to save it to a file, neither a method for that. It was an incrusted object, and I think that is the reason for that.

Then I tried to create the object by myself via VB, with the instructions:

Dim objeto_perfil As Object
Set objeto_perfil = CreateObject("Paint.Picture") 'IT STOPS HERE

And with the variation:

Dim objeto_perfil As Object
Set objeto_perfil = CreateObject("Paint") 'IT STOPS HERE

And neither worked. The error message says it lacks an object.

Then I followed an example from msdn that used a bound frame (view here ( The code is:

visor_perfil.Class = "Paint.Picture" ' Set class name.
' Specify type of object.
visor_perfil.OLETypeAllowed = acOLELinked
' Specify source file.
visor_perfil.SourceDoc = "C:RealPathimage.BMP"
' Create linked object.
visor_perfil.Action = acOLECreateLink 'IT STOPS HERE
' Adjust control size.
visor_perfil.SizeMode = acOLESizeZoom

It stops in the action assignation, an says "error 2753 there was an error trying to communicate with the OLE server".

I google a lot and could find much of the Paint.Picture Class.

Anyone has any ideas to overcome this issue? What am I doing wrong?

Thanks in advance!

View 3 Replies View Related

Lose Record Edit Via Form; Input Continues As New Record

Sep 22, 2004

PROCESS AS DESIGNED: The user logs in and is given a form displaying existing records that are coded (by userid) for that user to update. From that list, the user selects a record and continues to a second form (the first form closes) which displays all the fields of the selected record which should/can be edited by the user (plus a few non-editable key fields). There is nothing tricky to how the records are selected for display. A simple query behind the first form selects data records using the userID number. The second form does a simple record select using the active record ID number on the first form. Nothing tricky -- no modules just queries, tables, forms and simple macros to string it all together.

The user can open/close these two forms as often as necessary and the record will continue to show up until a value is entered into a "completion date" field. When that field is no longer blank, the record will no longer be displayed for use.

PROBLEM: About 90% of the time, things work as expected. But 10-15% of the time, somewhere between opening the record in the second form and closing the second form, the edited record totally disappears (as if it were never opened, it isn't even system date stamped) and the input information is inserted instead into a brand new record.

Users can sometimes tell when the edit record is dropped during processing, because key fields displaying previously entered data go blank and the displayed recordID (autonumber) is changed. p>
ERROR PATTERN: NONE! It can happen as the edit record is first opening, in the middle of editing the form, or at the end when closing the form. It will happen on a specific PC 2 times in a row and the third time be fine. It has happened at multiple locations but not for all people and not consistently for the same person/same pc. The same record that failed can be re-selected and work just fine the next time.

I cannot reproduce the error myself. I have tested everything I can think of without causing the error. I can lose changes and avoid a system date stamp if I abort my Access sesssion, but that doesn't create/insert a new record with my new input. It just loses everything.

I have wondered if a momentary break in the network/communications could break the connection to the application to just enough that the form remains on the screen, but selected record is discarded. Input into the empty form would/does insert a new record.

I have asked the IT Operations group to investigate if a network/communication problem could be the culprit, but they haven't gotten far on this. I have never seen this happen before and am totally stumped but am desperate to resolve it before user confidence is damaged.

View 1 Replies View Related

Need Form For New Record/edit Current Record

May 12, 2005

I have a table called tblFinishedGoods. There are 3 fields in the table:Serial Number, Model Number and Location.

I would like to have a form that will take input from my barcode reader and input the data for the 3 fields, if the serial number is not already in the table.(I have this already working).
But now I would like the same form to also check the table for any serial number that is scanned in...and if it is in the table already, have it bring up the model number and location for that record.

I'm thinking maybe there is something I can do with Serial Number afterupdate. Basically I'm looking for a way to not require the user to input anything via a mouse or keyboard.

If the 1 form could accept the 3 scans:Serial Number,Model Number and Location, and either 1)enter a new record if that serial number isnt in the table or 2)find that the serial number already exists and overwrite the model number and location with whatever the next 2 scans are.


View 2 Replies View Related

Searching Particular Record To Edit In Form

Jul 19, 2005

I have a form that assigns an Auto Reference Number to each record. Now the records are later edited. Is there a way that I can have the user enter the Reference number and come directly to that particular record that needs to be changed in the form. Like a dialog box that asks Enter Reference Number or something.

View 2 Replies View Related

Edit An Exisiting Record From A Form

Aug 11, 2005

I'd like to set up a form that allows you to enter a unique number for a record and then automatically change the value for one or more fields in that record.

I have a large number of records that I only need to add values to two fields so am looking to make a shorter form with the ultimate ail of doing this with a barcode reader.

I thought I could just add a line like:

Me.controlvaluetochangename.Value = "newvalue"

to and event property like after update and it would change the name for that record. Instead it created a new record with that value.

How do I go about changing the existing value?


View 1 Replies View Related

Forms :: Add / Edit New Record Only Continuous Form?

Mar 27, 2014

I have a continuous form with unbound controls. These controls write new records into a table using rec.addnew

If possible, I would like for the user to only be able to add/edit the new record only and not to edit the continuous form below. When I turn off edits on the form, I only get the new record to show. I found some pages that reference using code like .allowAdditons, .allowEdits and .allowDeletions but unsure of how to implement them since I have more than one control the user is entering data into. I also found another site that says to use a control to determine if the record is writable to: I do have a control that is set to =Date() on the default value.

View 13 Replies View Related

Forms :: Select Record To Edit In Form With Subform

Jan 3, 2014

I have created a form (races) with a subform (yachts in a race) to edit data in joined tables. It seems to be working well but I am having difficulty selecting which record to edit in the main form. I can scroll through the records until i get to the correct race but this won't work well when there are a large number of races to choose from.

I can see that I can use linked forms to select a race from a multi form or datasheet and call up my desired form by a double click on the ID field. This should work but isn't really elegant with users scrolling down a long datasheet to select the race record they want to work with. Is there a better way?

Races are uniquely identified by 3 attributes: SeriesDivision, Date & RaceNumber.I have created an index in the Race table for these 3 fields which forces them to be unique.I would love to create an interactive routine which asks users to select from a list for each of these 3 attributes and then returns the form for editing with the appropriate race record selected or even cascading - users select a SeriesDivision can then choose the valid dates for the selected SeriesDivision and can then select the valid raceNumbers for the selected date

View 1 Replies View Related

Forms :: Using TempVars For Form Open Criteria - New Or Edit Record

Apr 23, 2014

MS Access 2010 accdb - Using TempVars open forms either for New Record or Edit Record.

Two sets of forms - One set works perfect but the other will not accept the criteria for New Record

MsgBox checks confirm the Variables are still valid in the 2nd form Open Event yet the If Then does not work.

Just before the If Then, an invalid use of Null message appears.

View 2 Replies View Related

Forms :: Search Form - Select Record And Click To Edit

Aug 9, 2014

I have a form which displays the records from a query (i have included a picture of this form) and allows me to filter them and create a report from the filter.

I'd like to be able to select a record with the record selectors (or preferably without) - and then go onto edit it in a new window and save the edit...

If possible also to select a record with or without record selectors and click a button to delete the record


View 1 Replies View Related

Queries :: Allow User To Pick A Record From Continuous Form And Edit It In A New Window

Apr 3, 2014

I'm using the following code to allow the user to pick a record from a continuous form and edit it in a new window. For some reason my where condition isn't working properly as the edit form always opens to the first record instead of the record associated with the "Edit" button that was pressed.


Private Sub lblEdit_Click()
DoCmd.OpenForm "frmEditPlants", acNormal, , "[PlantID] = " & Me.PlantID, acFormEdit, acDialog
End Sub

View 6 Replies View Related

Forms :: When Duplicating A Record Duplicate Is Created But Form Remains In Edit Mode

Feb 25, 2014

I have a form with a duplicate record button.Sometimes when duplicating a record the duplicate is created but the form remains in edit mode (small pencil in the form margin).I also have a manual record counter on the form which does not refresh to the newest record number following the duplication? Both issues happen together and not independently.

I now have the standard MS Access record counter visible on the form to see whats happening and this always jumps correctly to a new record number when duplication is triggered, so when the problem happens the MS Access counter is showing one more than my own record counter.

If I use the standard MS Access record navigation buttons and go back and then forward by one record, the duplicated record is then corrected. The edit mode pencil is gone and both record counters read the same, which I assume has happened this has forced a save to happen

If Me.Dirty
Then Me.Dirty = False
End If

- in the current event of the form, would solve the problem, but it doesnt make any difference at all, its still no better, or no worse than before?Using CTRL + S removes the pencil, but doesn't correct my bespoke record counter?

View 6 Replies View Related

Create And Edit Image In Access

Mar 28, 2005

Hello! All,
I need to store a customer signature in the database so that we can take a print out at a later time.
I don't know how to go about doing this and thought that creating and editing an image within an access form should be a good option. But I don't know how to go about doing that either. So could anyone please help with this and also if you have a better idea, could you suggest that too. I have the application running on a tablet PC so there's something called Stickynotes too that comes with it. It would be great if someone could suggest a solution


View 2 Replies View Related

Use Access To Open Word, Create A NEW Document, And Then Edit The Doc

Dec 11, 2004

I want to create a new word doc, do a saveas to a specific path and file name, allow the user to edit the new doc, and then close it and return to the Access app. I can create the doc but Word opens without opening the New Savedas Doc. using this code

Dim oApp As Word.Application
Dim WordDoc As Word.Document
Set oApp = CreateObject("Word.Application")
Set WordDoc = CreateObject("Word.document")
oApp.Visible = True
WordDoc.SaveAs ("TS-" & Me.Scriptnum & ".Doc")

Your help is appreciated.

View 1 Replies View Related

Forms :: Capture Users That Create And Edit The Records

Aug 27, 2013

What is the best way to capture the users that modify the records in the database?

Let us start from User Log-in Form After log-in, Main Form will open The main form has various menu (example Add Customer) Once I open the "Add Customer Form", I want to record the username in the Createdby/Editedby Field automatically.

View 5 Replies View Related

Forms :: Edit Record From Query Result As New Record To Another Table?

Aug 22, 2013

I have a form that using "Query A" as data source. The Form need add (edit) a field value before save that Query Result to another Tabel. Is it possible to do that?

The PROCESS simply like below: Tabel A --> Query A --> Form -->Edit value a field -->Save to Tabel B

if it is possible, are there some requirements that have to be fullfilled?

View 2 Replies View Related

Create New Record With Form

Jun 22, 2005

How do I create a new record (in the table to which the form is bound) automatically if, when the form opens, there is no record in the table that meets the criteria in the form filter?


View 1 Replies View Related

Linking Form To Search Or Create New Record

Mar 16, 2005

I have uploaded an example of my database

As you can see there are two tables and two forms.
What i want is for a user to view or enter data for a record on the first form.
And then when they are done they click the button to open up form2.
What i want to happen is for the company name/id from the record in form1 to be searched for when form2 opens and to display only the data for that record when opened. If no data exists for that record in form2/table2 then for it too create a record for that company when form2 is opened from form1

hope this makes sense and you can help

Please note this is just an example so if there is wrong naming conventions and such please ignore if there is as i just wanted to display quickly what i want to acheive

View 13 Replies View Related

Simple: Create A New Record, Update Old Form

Apr 12, 2005

Hi... I searched quick, didn't find anythign, but you guys are so responsive... :D

Part 1. On TimeSheet form, I want to click to "create new job", and the Jobs Form opens, at a new record. Currently it opens at record 1.

Part 2. I foresee that when I return from the modal job form, the old form (timesheet) would not have updated the combobox to show the jobname I just entered.

I guess this is what subforms are, because I keep reading about them, but dunno what they are.



View 5 Replies View Related

Create New Record On Form And Subform Simultaneously

Apr 9, 2006

When I click the new record command button which I created I get a new record, but the form has a subform and this starts with no records. How can I program this button to not only create a new record and the form to which it relates, but also to create a new record on the subform contained within it as well??

View 3 Replies View Related

Create A New Record, Opening A Form Based On The Key Field

Jan 28, 2005

I seem to need some help!
I have a table with customer information in it ie: name, vehicle, (Key=Id number)...
it is the master link to the repair table ie: mileage, (Key=ROnumber), and repair data..
these two work together beautifull
now I need to add another table, a check sheet for checking over a vehicle.
I create the table and the form however I cannot open a new form with the ROnumber from the second already open form into the newly open form.
(the second form is based on a Query, and I have tried changing it to a SQL statement both with no luck)
is there an example of what I need to be doing to link the ROnumber to the ROnumber in the new form, or create the ROnumber so it will add the data in the linked table?
I need this to open using a button on the open repair form

View 1 Replies View Related

Modules & VBA :: Button To Create A Record And Open Form

May 7, 2014

What I need to do is press a button on a form. When the button is pressed, I want to create a new record in a table not already open and populate some fields with data from the form I am looking at. Then call up a new form with the record I just created on it.

Basically it is a work-order entry issue, the user scrolls through to find the correct piece of equipment when they do they click on "Create work-order" a work order is created and populated and the user can then fine tune the new work-order as required.

View 13 Replies View Related

General :: Button To Create Invoice Per Record On A Form

Apr 18, 2013

I am creating a database for a local mechanical garage, most of it is setup but i have an issue creating invoices, I need to create a button on a form which will create an invoice per record. Trouble I am having is if i have 1 record it will show just 1, but when i add multiple records they all show on 1 invoice sheet. It doesn't separate records, i but instead it adds the extra records before the page footer :/ causing 1 footer for many records. How to finish the functionality of this DB, i can certainly finish the design side. Everything in this DB is set accordingly, just the invoice system to do i believe, could some1 have a look and let me know? i have tried to upload it here but cant so its on this link [URL] ....

View 3 Replies View Related

Copyrights 2005-15, All rights reserved