I have a form that I created using autoform from my main table. The form is just for the user to enter a new record. But when opening the form, how do I get the fields to be blank and on a new record by default, rather than starting on the first record with the fields already populated?
And then if I make a button that says "add" but just closes the window, the data should automatically save right?
Thanks.
Hoihoi, Well, Hello..Never thought I'd register on an Access forum, but, hey, why not!I'm new to Access, never really liked it..but this assignment has changed me.. i really like Access and well DBA'ing in general!I need a bit of help with a few things:-----I hate registering on sites JUST asking for answers >< I hope to learn a lot of stuff from here!-------Just like to add it's for an Assignment at college, i KNOW I KNOW you people can't help with assignment work, BUT it's not like i'm asking you to do it for me, just need a bit of help Basically,I've got a database -It's based on a Mobile Library which visits nurseries.The nursery can loan a book, if a book is currently being loaned by a nursery and another nursery wants to loan that book, they can reserve it untill it is returned.Basically, I've got a few forms:21233I can do everything fine!Everything seems to work, i can loan and reserve..i can add books, nurseries and authors..HOWEVERwhen it comes to deleting.. it's a different story!On my delete_author form, I've got a Combobox which loads the authors and then i've got a Delete button which should delete the author which is in the combobox---- I've google'd for ages..and can't make much sense of any of the replies people have had..Is there anyone who can help me with this?Delete the author which is in the combo box..I can supply any details if people are willing to help :oWould LOVE to hear a reply from anyone!Cheers :)
View 14 Replies View RelatedI am fairly new to access so please excuse my lack of knowledge. I am using Access 97
What I am trying to do is create a system where I ask for a zip code, then disply the closest 5 results to that zip code.
I currently have every single city with ZIP code in Michigan. I also have the list of results with their zip codes.
Since you cant relay on ZIP codes going in order, I also have the Latitude and Longitudes for each ZIP code. Of course I have the lat and long for my possible results.
How can I get the 5 clostest results based on two different factors (Lat & Long)? Would I want to construct a Query to do this?
Any tips or sites you can refer me to would be great! Thank you!
hey,
Am new to the forum and it seems a good place for help,
Am having some big problems with a database that i am using for a company. The problem being that users need to enter ref numbers for each record on to the database called "c3" numbers, there could be a unlimited amount of these numbers(they do need to be able to reported on though) per record
At the moment i have a serperate form linked to my original form with a lot of seperate fields labelled like "c3number", "c3number1", c3number2" and so on which the user enters the c3 numbers into ans saves
however it is becoming very hard to do counting reports with it set up like this.
has anybody any ideas's on how i could make the setup simpler?
many thanks
Steve
Ok, I have studied up on relationships, and read a lot of these threads but, I still have yet to find help. It seems a lot of the people on here have difficult problems that require dificult answers. Basicaly I have two tables Tblresort and Tbllifts, now there can be many chair lifts for each ski resort, so this would call for a many-to-one relation ship. Now, I create a relationship for the fields, and enforce refrencial integrity and all that. Now what do I put into the related field in Tblresort to get the lifts with ID#'s 1-8 to be related to the first resort.
I hope this all makes sense, so far I can only get one lift conected to the resort.
Thanks in advance
I have to create a new table for some data I have from work. The data was imported within quotations though, so it won't let me copy and paste it untill the quotes are removed. I have over 3000 data values in each column, so I can't just go through and delete every quotation mark. Is there any way for me to select a column and remove the quotations around every value?
I have the XP version, by the way.
Thanks !
I am brand new to Access/VB as of Thursday. I am an aspiring programmer still in college. My proficiencies are more to the c++/HTML side of things right now, but I am in dire need of some assistance. I was recently given a series of projects to determine if I am qualified for a particular job. I have completed them all but one. I am modifying an invoice form in Access. I have accomplished all but two of the tasks on this last project. I need to modify the invoice form so that whenever a payment amount is entered, the payment date box I created populates with that date. I know I'm really close to it, but I keep getting errors and the only thing populating the box is #Name?. I also need to open up the print/preview mode of the invoice report when I click the print button as opposed to the current form it opens up to print from right now. If anyone could offer any assistance/advice on anything...even a tutorial that might point me in the right direction that would be excellent. I have until Tuesday to figure this out =) Thanks a bunch in advance!
P.S. This is where I thought I needed to execute the update for the payment date since it is where the payment is entered. If this doesn't help at all then I apologize.
Private Sub I_Payment_Exit(Cancel As Integer)
Me.I_Tax = NullToZero(Me.I_Subtotal * Me.I_TaxPerc)
Me.I_Total = Me.I_Tax + NullToZero(Me.I_Subtotal) + NullToZero(Me.I_ShipChg)
If Me.I_PaymentLock = True Then
Else
' Me.I_Payment = Me.I_Total
End If
Me.I_Balance = Me.I_Total - NullToZero(Me.I_Payment)
End Sub
Hi. I'm quite poor with Access, so sorry if this sounds dumb.
I have a table of customer records (tbl_customers), including name, address & postcode etc
I have a spreadsheet of customers their postcodes from a different system that shows customers who have bought a particular product.
Is there a way that I can create a query that lists those records in tbl_customers whose postcode is matched in the spreadsheet?
Jim
Hiya,
Sorry to add to the email threads, already posted on this forum. I have already searched on the forum for the relevant help but im still struggling. As am a newb when it comes to this sort of thing, and everythink is an on going learning curve.
Background, i work for a architectural firm, my boss would like the database to send out automated emails, to the local planning authority.
I have a query called "ApplicationEmailCouncilQuery" in this i have the following fields. ApplicationProjectID, ApplicationSubmitted, ApplicationRef, ApplicationDecisiondate, ApplicationContact, PlannersEmail, ApplicationEmployee, Email.
How do i get access 2k to automatically send out emails to each of the results individually as produced fromt he query, every 2 weeks.
I want the email to use the fields from the query.
To: "PlannersEmail"
Send: Your Application ref is "ApplicationRef" submitted on "ApplicationSubmitted"
Message: To ApplicationContact,
Please could you give me an update on the application "ApplicationRef" which we submitted on "ApplicationSubmitted".
Please reply to this following address "Email"
Yours Truly
"ApplicationEmployee"
-----------------------------------------------
Sorry for the long post, any help on the above matter would be greatly appreciated.
Thanx
Keith