Hi there, I'm fairly new to access. I hope you can help me.
I have an update query that creates an entry for my stock and the date. This runs every time I run access. I only want one entry per day though :confused:
At the moment, every time I run access another entry gets appended.
Thanks for your time,
Robin
I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.
Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.
I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.
View 3 Replies View RelatedHow do I make data entry required, I've sent it to be in the table but it doesnt seem to work in the formI've tried the below with no luck Private Sub Command14_Click() If tbName = Null Or tbTelephone = Null Or tbAddress = Null Then MsgBox "Please complete all details.", vbExclamation Else DoCmd.Close DoCmd.OpenForm "frmInvoice" DoCmd.MoveSize , , 5100End IfEnd SubCheers
View 1 Replies View RelatedHello, I'm trying to search an entry of a recordset with VBA
The entry can only be found by searching 3 field values. In my case the correct entry can only be found if the data in the field Date, No_Employe and No_Project all match the data of the entry I want.
Findnext doesn't work, it only access one field and I need three.
Seek doesn't work since it need to search a key, and neither Date, No_Employe or No_Project are keys.
How can I proceed ?
Should I use multiples Findnext ( how do I do that ? ) ?
EDIT :
Also please note that I'm searching for 400-500 entries in a row, so speed is an issue.
Hello,
I'm looking for opinions on how people like to enter information into a many to many relationship.I understand how a many to many works as well as a Main Form/Sub Form.
Subforms is what I currently use. Would you do anything different? Below is a sample of fields I currently have. Any advice? I keep wondering if there is a better way. I'm not a huge fan of sub forms. I also build lookups from the Junction. Is this correct?
tblProjects
ProjectID PK
Project
Date
Budget
tblProjectsandManagers
ProjectID PK FK
ManagerID PK FK
tblManagers
ManagerID PK
FirstName
LastName
Phone#
Thanks
I have an input box that gets a string from the user. I want to put that string in a table. How would I do that?
View 4 Replies View RelatedI have a table called Tests that contains 80+ tests that need to be performed on our system. A second table is Test_Data. It contains the test results. I need a query that will pull the most recent test data for each test in the Tests table. So supposing there are 83 tests, I should only get 83 results from my query. I am will need to join the tables as I need to get some of the descriptive information from the Tests table. Another problem I have is some tests have not been performed even once, so not every item in the Tests table has a corresponding entry in the Test_Data table.
Any thoughts on how to do this?
Hi,
Im having a little problem with the following code in one of my queries
Expr1: IIf(IsNull([Forms]![editLookForm]![Company_Name]),True,[Company Name]=[Forms]![editLookForm]![Company_Name])
What this does is, it take an typed entry from the form (editlookform) and seaches for that entry in the query
i want to add wildcard entrys to this so that the person operating doesnt have to know the complete company name - i just dont know where to put them
Help please
i am editing the user interface for operators.
here is the issue:
operators are entering data but sometimes forget to put the part serial number. they then go to the entry.
this is what i want to do:
the operator will not be able to go the next screen (complete the entry) unless they enter the part serial number. where and what should i enter that will prevent the issue?
much thanks.
Hello,
Is there any way to sort a query by last entry? Unfortunately, this would be the only solution to a design error. Thanks much.
Pat
Is there any way to sort a query by last entry? Unfortunately, this would be the only solution to a design error.
View 5 Replies View RelatedHello All,
Is there a way to retrieve the very last entry to a table (via a query) without passing a value to the query.
Lets say I have a table Pets
ID desc
==============
1 Dog
2 Cat
3 Lizard
For example lizard was added last, is there a way I could pull just this out using a query? (keep in mind that I don't know wahat the last entry is, so I cannot pass any kind of value to the query)
Cheers,
Aaron
Hi..
I have a form with a subform where the user has to enter some data in them. when the user moves to the subform the data in the form automatically get saved in the table(you all know that i suppose).
In the form i have a back button where the user is able to go back to the main form.the code of the button is:
If MsgBox("Do you want to save before exit?", vbYesNo, "Save") = vbYes Then
DoCmd.RunCommand acCmdSave
MsgBox ("Data has been saved.")
DoCmd.Close
DoCmd.OpenForm "Main"
Else
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.Close
DoCmd.OpenForm "Main"
End If
Else
DoCmd.Close
DoCmd.OpenForm "Main"
End If
my problem is when the user hasn't entered any data and wants to return i would get an error (because i'm trying to delete a record which doesn't exist
) how can i check if a record has been eneterd.
if new entry then
deleterecord,close,open mainform
else
close,open main form
endif
thankxx in advance..
hope my grammer is correct
Hi,
I would like to know what code I need to populate a field with the last record information - similar to the Ctrl apostophe.
I can upload the database in question if required.
Thank you
I have a data entry form and some records in it. What will I do so the entry form and records will not be edited when viewed?
View 2 Replies View RelatedI tried using a message box to try and validate text entry on a form into a bound txt box 'PaymentAmount', If there is no payment entered, using the properties box Validation Rule ,- 'is not null' then entered a validation text ="Please enter an Amount" but this does not work. How can I get a message box to appear if someone leaves the entry field empty so that they have to make some entry to move on. I have already entered this in the table validation field as well as 'Required - yes', but the message is an Access one not my own. Where or how do I do this ?
View 14 Replies View RelatedHow do I make it so that while filling a new entry in a form, the form's fields contains by default the previous entry's values ? So if for example the user put "20,95$" as the hourly wage for a person, once the user makes a new entry it puts 20,95$ on the hourly wage of that person ?
View 3 Replies View RelatedHey,
I've been looking at this website (http://learning.north.londonmet.ac.uk/ib212/week7/validation.htm) and i'm trying to find an input mask that lets a user enter in an I.P. address like the IP settings in Network Connection > Properties > TCP/IP > Properties.
E.g. a user enters 19216802. I want this converted to 192.168.0.2 without the user having to enter any '.'
So far this is the closest i've gotten to validating the field
0##.0##.0##.0## whereas 0 means something has to be entered and the # are optional.
Thanks,
Barret
I have a combo box(based on a table) on a form which autofills 12 textboxes. The problem is when i switch to the next record on the form the auto filled textboxes stay the same as the first record. when a new item is selected from the combo box all the records are changed once again. I dont know if this is explained well enough but any help would be great
View 3 Replies View RelatedEach pay period, I must enter data for each employee that worked an extra shift. The table is simple:
Name
Period Starting
Period Ending
Number of Extra Shifts Worked
Is there a way to bulid a form that will keep the dates I type in the period starting and ending fields until I change them?
To clarify, I have 17 employees who worked extra shifts, and I don't want to have to type in the Period starting and ending dates for EVERY record. Thanks in advance for any help. I really appreciate it.
KellyJo
I want to add a system of getting unique numbers into my database based on the month followed by a unique 3 digit code. For example, if it is February and this is the first record then the reference will read 02/001. Any ideas how I would go about doing this.
I've set up a seperate table called Reference numbers as these reference numbers will be used on any number of forms.
Cheers,
Recall.
I have a Timesheet form where you select your name from a combo, and you select a Timesheet Period from another combo. Then you can enter various details in the sub-forms.
I want to prevent a user from being able to enter two timesheets for the same period. What's the best way of achieving this? I would like a pop-up to appear saying "You have already started a timesheet for this week. Please use the Update Form Dialog"
The timesheet form is bound to tblTimesheets which contains fields TimsheetID, StaffID, and TimesheetPeriodID
In cboNameSelect, StaffID is bound
In cboPeriodSelect, TimesheetPeriodID is bound.
Thanks
S
I have a table where records are updated regularly with new information [date & engineer] & the old information over written.
What i want to be able to do is every time a field is updated with new data, write the new data to a second table as a new entry so that i have an archive of all old records held in a second table.
Thanks for your help in advance.
Larry.
I have a data entry form and some records in it. What will I do so the entry form and records will not be edited when viewed?
View 2 Replies View RelatedI've got two tables, Properties and Valuations. Every six months the properties are revalued. I want to have a datasheet list of all the properties with a blank field for the new valuation so that the user can just go down the list and enter the new amount without having to select every property individually. Can I do this?
View 5 Replies View Related