I have made a simple form this is my first form in access 2003 and when I go to save record and close out and I open the form again the inputs that I did to the form do not save. Also It wont let me click on the new record button or anything.
Any help thanks
Newbie Need help !!!!!!
downloaded a template from microsoft for contacts played around with the form to suit myself...
the problem i have is when i enter any thing in the text box this is cloned to all records this is happening with all text fields im not a programmer so plz go easy!!!!!!
thank you
Newbie Need help !!!!!!
downloaded a template from microsoft for contacts played around with the form to suit myself...
the problem i have is when i enter any thing in the text box this is cloned to all records this is happening with all text fields im not a programmer so plz go easy!!!!!!
thank you
I've created a macro for saving records, but it's just over write on the previous record, what's the best way to save new records using forms?
View 2 Replies View RelatedI am using access around after 15 year, now I am trying to build small database for my budget purpose
Here is the situation example:
FY2013 = Total working days
Period 1 = No of working days & expected Exchange rate
Period 2 = No of working days & expected Exchange rate
so on........
Period 12 = No of working days & expected Exchange rate
Now once i done - I want to save all record in single go, plus since this budget - total working days can't be change therefore, to avoid any error made by someone, i would like to save Total working days = (Period 1 ++++++++ Period 12)
Hi guys and girls,
I'm fairly new to Access and I'd appreciate some help. I've built a form with buttons to open new forms for that specific record (based on queries as all the data is held in a single table). This works fine until I try to add new records. At the moment the only way I can make this work is to add the new record, shut the original form before re-opening it and proceeding on to the other sections (via the buttons I mentioned).
If anyone could tell me how to get Access to save the record before it opens the other forms I'd really appreciate it.
Cheers,
Franny.
I'm using Access 2010 and now trying to save a selected record to another table which I have no clue where to find the "Code Builder" to put my code on after spending hours and hours, I managed to create a form, but couldn't figure out where to save this data.
All I need is to put this line
"INSERT INTO ResultTable (StudentID, CourseID, PaidID, Comments) VALUES (" & cboStudentSelect & ", " & cboCourseSelect & ", " & cboPaymentSelect & ", " & txtComments & ") WHERE StudentID = cboStudentSelect
Perhaps, the new Access 2010 doesn't use this or something new that I couldn't it.
Attached is the file.
I need to create a record of Users. I created a form with fields containing Username,FirstName,LastName & Email Address wherein the UserName is equals the value of the fields FirstName & LastName. I have a save command button and when I click it, I want it to be able to check if the new entry has a similar UserName that exists in the database, if it exists then it will allow me to edit the UserName and then save the data otherwise will allow me to save it.
View 3 Replies View RelatedI've been working on a database for work for the last few weeks and this forum has been a Godsend many times over, but now I have a problem that I can't find any reference to.
Using Access 2003, I have a form that uses 3 cascading combo boxes in the header to find a unique record, and a command button that brings up the rest of the record into unbound fields in the body of the form.
It works fine for finding records, but whenever I enter/change data on it, the record doesn't save. The navigation buttons at the bottom don't work - the Next/Previous record buttons are disabled, and the First/Last Record buttons do nothing.
Navigation buttons are enabled/activated in the properties.
I tried getting around this by creating a Save Record command button - first using the wizard, then using VBA code DoCmd.RunCommand acSaveRecord as advised by [missinglinq;696351], but this still doesn't save the changes.
How to restrict the updation of a record while entering until a save button is pressed on the form ???????? is it possible without the vba ?
View 10 Replies View RelatedI am working on a web database with a form which is bound to an underlying web table where the submissions occur.My challenge is that the fields on the form get submitted to the table even before the submit button is clicked regardless of whether the form was completely filled.
My request is that I want the form to only submit to the submission table only when the submit button is clicked.When I searched on the net, the only solutions I got are VBA written code but my web database cannot use VBA code.
VBA code:
Option Compare Database
Option Explicit
Private blnGood As Boolean
Private Sub cmdSave_Click()
blnGood = True
Call DoCmd.RunCommand(acCmdSaveRecord)
blnGood = False
End Sub
[code]....
So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.
I am using Access 2010.
How can I make certain my user enters records on a subform before attempting to save the main form? Right now they can completely ignore the subform before saving the record.The Main form has business address, etc. on it. the subform is bound to a join table that lists the multiple categories, subcategories and sector the business is listed in for a directory.
I already have my fields set to required at the table level in the join table, and have some existing VBA in both my subform (to update edited date) and my form (to validate empty records where a certain condition is met) but that's not the issue...
How do I focus the user to enter a record on the subform to the point where they are forced to enter something and complete the subform before the record is updated.
I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an On Click event procedure?
View 4 Replies View RelatedI need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !
View 1 Replies View RelatedGreat forum!! Hope I someone on here can help me!
Here's the situation. I have a Database in Excel (~3000 rows & 7 Columns)
The first Column has numbers like this (3-10-34 or 223-7-45) the other columns have names, addresses and other stuff.
What I'm trying to do is to eliminate the use of huge binders. I want to have a Blank screen with only one input box where I can type a number and retrieve a specific row from my Database. Time saving.
Now, when I'm searching, I usually only have the first numbers before the dash (such as the 3 or the 223) not the other numbers. So I cannot input 3-10-34 for instance. I can only put 3...:confused:
I've already imported it to Access and it works fine but have no idea how to do what I just described!
Thanks for the input!!
A very very green access user! :o
Hello
sorry if this question is answered somewhere else i did check through the forum a bit first
anyway to the question
is there a way in access 2003 so when i change a value in one table it creates a new record in another table
example
i have a table called tickets and one called fixes, when i change a value in a record in the tickets table i want a new record in the fixes table to be created for me
any help would be great
ADAM
Hi there,
I am not sure if i am supposed to post in this section......
--------------------------------
Using Access 2003.
I am very new to Access and have started off very well building my first project..
My help is that i would like a macro button to delete a record once you have put in to the database if that is possible also i would like a save button if that is possible...
I have put a Tab Contol on and want to change the backgound but i can't see on the properties box to change this. Is there a piece of code that allow me to do so...
Hope some one can help
Emailjunky
Hi There All,
I am still very new to Access 2003 and have started off very well..
Just a few help please:
Help 1. I need a macro button that will allow me to delete a record from the database via a form.
Help 2. I need a macro button to save the database if that is possible via a form.
Help 3. I have a Tab Control on my form and i want to change the background of the Tab Control but can't find it on the properties is there a piece of code i can put in to VB which will do this for me or is there another way.
Hope someone can help
Emailjunky
hello guys i m very new to access and i need some help!
if i had a form that contains a field like salary and i need to add all the salaries from all the records into one total salary how can i do it?
plz take into consideration that i m totally new and dumb:p in access
thank you
Alright here is what I am trying to accomplish. I have A, and B. Then I have 6 different tables that relate to the six different things B could be and contain all sorts of other information.
What I want is to make a form that lets you type in A, and B. Then the correct table/form for the respective B will pop in to the subform area. Then as soon as you select or type in a new A and B, the subform will change, or stay the same if the B has not changed, but a new record will have started.
"A" is just an ID... something like AA001, AA002, etc.
"B" is the stage each ID is at... like beginning, middle, end, etc.
Sorry if it is a bit confusing, I am willing to explain any details that could help. I consider myself a somewhat advanced Access user, but this just stumps me for some reason.
Hello all,
Im looking to create a frontend and backend for a Dojo (Martial arts center).
Basically, it will log in people(record their training time, by day not hour) either by Number or name.
Secondly, I want to be able to have all these fields seen by the admin:
Dojo Number
Date Joined
Last Name
First Name
Male/Female
Address
City
Zip
Home Phone
Work Phone
E-mail
Birthday
Occupation
Adult/teen/child
Rank
Active/ Inactive status
Martial Art Exp.
Staff Y/N
ASNJ Dues Info
USAF Dues Info
USAF Membership Number
Misc. Notes
So the backend/ admin would be able to update this field and keep records up to date.
There would be around 800 entries/people, and only one admin accessing the db at any time. The frontend would be used to log in..
Hi,
Can some kind soul help with pointing me in the right direction to a problem below?
In my database (property database), I have some old properties which are now sold. There are relationships between property, rent received, billing, lessees, etc. I want to be able to keep the details of the 'sold' properties.(i.e., who owned it, what they paid in the past, when they paid etc. in case I need it, but don't want it shown any longer on the main working database). I want to be able to delete the properties that are sold from the main table. Any ideas how I go about this? Hope I've explained myself ok.
Thanks
HMC
I have recently created a database which exports a daily report in Excel. The problem I am having is that the reports are sent out in Excel 95 which cannot be opened by Blackberry. We used to create this report from an excel database and send it out but it went out in excel 97 format which was readable. As a complete "Access" novice I am at a loss on how to cure this problem short of copying the excel 95 report which we create automatically and cutting and pasting into excel 97.
Over to the experts.
Hi All,
great forum here, loads of help and really busy :D
im very new to acces and have never used it before, however i have been using excel and VB for a while.
Ive been given a large table with about 5 fields in it and 40k + lines of data (!)
I need to write some kind of program/query, where i can input some txt and it will then lookup all the data that relates to that input txt.
Eg.
Car Tom Red
Car Tom Blue
Bus Dave Red
Bike Tom Pink
If i did a seach on "Tom" it would then give me the 1st, 2nd and 4th lines (all the info in that whole line)
If i did a search on "Red" it would give me the 1st and 3rd lines?
Im sure this is very simple, so any help would be great :)
Also, really sorry if this is in the wrong location, please move if so!
Very much a novice here
What im trying to accomplish is so simple its silly, but i cant figure it out for the life of me
I have a field id like to restrict entries to the words Buyer and Seller, and i'd like it so that in the form, if the user hits the letter B, Buyer fills in and if S seller fills in ...
What can i do in the table to accomplish this?
Thanks so much