General :: Check If Item Is Available To Hire

Jan 31, 2013

I have been creating a Access database to hire bikes out. I have created all the tables etc but i am stuck creating a query i want to create. I want to have a sub form on my booking form from a query which will show all the available bikes that can be hired. I have looked at the lending library sample and this hasn't really worked, My database is set out differently.

I have attached a version of the database to the post, this is zipped with some screenshots which may be useful.

View Replies


ADVERTISEMENT

General :: Get Latest Record Added Of Item - Check Period Between Now And Date Saved

Sep 28, 2014

In my Access app I need to get the latest record added of an item from a MS Sql table and check the period between now and the date saved in the record.

So my guess is:
Select TOP 1 * from tbl_StockItems
Where StockId = Loc_StockId

I then need to check the days between tbl_StockItems.LastStockDate and Today.

How would I write an Access VBA query to give me the amount of days and put that number into a variable.

View 4 Replies View Related

Querying A Check Box Item

Dec 15, 2004

Hello everyone I am an access novice in seek of some help,

I'm trying to add a check box to my customer table and then query all the rows that have been checked. How do I go about doing that?

I've put together a very generic database of how I would like to do it. Including the table, form, and query.

I'm just stumped on this issue for some reason.

Thanks for your considerations,

Nick

View 1 Replies View Related

How To Check Same Item Is Not Entered

Nov 30, 2013

I have two four tables. Invent, trans, NewOrder and reorder tables. The new order table is not joined by a relationship unlike the others which are joined with the Invent ID field.

The new order table has the fields(ID,QTY,NAME,Order Date). I want to use this to order new items that are not in the Invent table. What do I do to check that I don't enter a new item name in the NAME field that is already present in the Invent table?

View 3 Replies View Related

Hire System Help

Nov 27, 2006

I have two tables, one named Loan and one named DVD Details.

On my DVD details table i have a field name, on_loan with a data type yes/no.

I have created a form called LoanForm where i want to select a DVD with a combo box,

then select a Set loan button that will set the corresponding DVD on_loan field to yes(true), in the dvd form.

on the button i have the following code


Private Sub HireDVDButton_Click()

Update dvd
Set car.on_loan = True



End Sub


But it doesn't seem to set the on_loan field in the DVD table to true, which is what i want to do.

Sorry if it's not clear what i want to do. I am just a beginner.

Thanks in advance :)

View 1 Replies View Related

Where Do I Hire Access 2000 Database Help?

Feb 18, 2006

Can anyone direct me to someone that does work with Office 2000 Developer
to complete a database runtime version. I paid Microsoft for help that was expensive and all i got was suggestions to but more software. I own Office 2000 Developer 2000 version 1.5. Its a small job so I dont know where to start looking for someone to hire.
Thanks

View 11 Replies View Related

Hire System - Append Query

Apr 6, 2005

Hi,

I am trying to creat a booking system for cars which has a specification of being able to be hired by the 'week'. I am thinking of creating a table with every week date (every monday) from Feb 28 2005. Just wondering how I would create a table do to this with an append query?

I was thinking something like looping from Feb 28 2005 (monday) and dateadd + 7 a few hundred times then having an HireID field in the same table and once a car is booked for a one week period its start date hireID (or CarID) are entered into the database so nothing can be double booked.. I am just not so sure how I would reuse each date for all the different cars?

Any ideas on this are much welcomed.

Thanks in advance,
Scott.

View 5 Replies View Related

General :: Add / Delete Item From Listbox?

Sep 30, 2012

I have two list boxes on a form. The first listbox contains CATEGORIES and the second contains ITEMS that belong to respective categories. So, when i click a category the next listbox displays the items that belong to that particular category.

I need to know how to add new items to a selected category and also delete items from a selected category. If no category is selected or item already exixts, item should not add.

View 3 Replies View Related

General :: Assign Next Item To Next User?

May 6, 2014

I have a list of inventory (SR #s) in a excel under column A. And also there are 20 users using ms-access accessing by their user names. If a user completes one item, the next item from the excel should automatically goes to the next available user. After the item allocated to the particular user, under column B the user name should come and in column C there should be a comment saying "Done" Can i have a code for this in SQL or VBA.

View 2 Replies View Related

General :: How To Remove A Item (double Var) Of Listbox

Mar 21, 2013

I have to do a app in access2003. My problem is when i try remove a item of a listbox not do it right. Example.

values of the listbox:

1
2,5
3

If i remove 1 or 3 not problem but if i try remove value 2,5 my list box show:

1,5
3

why??

my sentences if like this:

listbox1.removeItem(listbox1.ListIndex)

To introduce values i do a query and put them with listbox.addItem(value)

Perhaps any property of the listbox or something i am making wrong.

View 3 Replies View Related

General :: Drop Down List With New Entry Item

Aug 7, 2012

Drop down list equipped with new item input provided. My application now use a drop down list to access/display a form with certain item selected, but I want to entry new item using drop down list which equipped with "entry new item" then I hope the form can be accessed belongs to new item.

View 1 Replies View Related

General :: Display Listbox Record When Double Click On Item

Sep 26, 2012

I currently have a listbox. (list32) that is populated with results of a query. I would like to doubleclick on an item and have it open a form that displays the listbox record i clicked on and a "notes" field. Its my understanding that the table fields are limited to 255 chars so i was curious if I could make the notes field reside somewhere else. I will need the notes able to be edited, specific to record entry, and then saved on exit. Is this doable?

View 2 Replies View Related

General :: Order Database - Discount Table With Percentage For Each Item

Aug 23, 2013

I have been asked to create a database that creates orders, debits stock etc for my company. Now I have been asked to put in some kind of discount table with percentages for each individual item for each individual customer. What would the best way of doing this?

I figured in the Customer Table I would have a code such as 'CustomerADiscount' and 'CustomerBDiscount' etc. and then in my table maybe

Product A - CustomerADiscount - 10%
Product A - CustomerBDiscount - 20%

Product B - CustomerADiscount - 5%
Product B - CustomerBDiscount - 7%

This link these values up within a query? Would this be the best way of doing it?

Is Access able to determine a percentage in "10%" or "5%" or do I need some type of formula for it instead?

View 3 Replies View Related

General :: Access 2010 / Combo Box Not Displaying The Correct Item?

Apr 28, 2013

Using ms access 2010, I created a table called all items contains the ID, item name, item code, item price.

Second table I created called orders, contains item1,Q1=quantity,Tot1=calculated field.

Then a form to fill the orders table with a combo box for Q1 (gets the value from a table called numbers), second combo box for item1 (gets the value item code and item price from the table all items), and a text box to calculate the total of the Q1-item1(item price) All working perfect except the combo box for item1 ends up displaying a different item code that's only if the items were at the same price, for example, I choose latte from the combo box gives me correct item price but the code is cappuccino, only happening with items with the same price.

If I set the property of the combo box Bound Column to 1, I get correct item code but calculation error, Bound Column to 2, I get correct calculations but wrong item code. how to get the combo box to display the correct item code?

View 1 Replies View Related

General :: Select Item Number From Drop Down Box To Create A Report

Jun 27, 2012

I'm currently working on fixing an older 97 database that I've updated to 2010. I have just populated the Drop down box with about three fields. Ideally what I want to do is after having selected the item number from the drop down box I then hit the button that creates a report with the information about that item number.

At the moment...If the box is blank it reports all the item numbers, however if i fill the box(select an item) it returns nothing i.e the report is blank.

I've looked at the query that builds the report, there are only three fields that populate the. location, part number and description. from a tbl called MainDetails

the only other thing:
If([Forms]![frmReports]![FLoc] Is Null,[FUNCTIONAL LOCATION] Is Not Null,[FUNCTIONAL LOCATION] Like [Forms]![frmReports]![FLoc])
it has a criteria of <>False
*FLoc is the drop down box *functional location is the location field.
I believe all the above does is populate the report if Floc is empty.

What can I put to make the report generate what ever I pick in the drop down box 'FLoc' source the three fields from the 'MainDetails table'.

View 7 Replies View Related

General :: Saving Invoice With Multiple Lines In The Item Section

Jun 17, 2014

I want to make an invoice with products and services and totals, the thing that has me wondering is how do I save an invoice with multiple lines in the item section of the invoice. I want to be able to choose a customer and then see the list of invoices connected to that customer, and when I click the invoice to open it as it was. What would be the best way to do this?

The invoice contains:Customer info, adress, name...etc

List - multiple lines of products sold / services completed
Totals, date & time...etc
Relationship goes like this: Customer -> Invoice <- Inventory / Services

View 3 Replies View Related

General :: Create New Table By Item ID To Show Balance Of Stock

Feb 17, 2014

I have created 3 tables for simple inventory.

a) Item details
b) stock in
c) stock out

All I simply want to do is create a new table by item id to show balance of stock.

View 2 Replies View Related

Setfocus On Repeating Item/accessing A Specific Item

Aug 18, 2006

I have a form that simply lists the items:
DEPARTMENT_NBR and DEPARTMENT_NAME

In the table: DEPARTMENT_TBL

When I edit the field DEPARTMENT_NBR and it is in error (must be between 01 and 99) I want to put out a message in a MSGBOX and SetFocus back on the DEPARTMENT_NBR.

I coded the MSGBOX with vbokonly and then DEPARTMENT_NBR.SetFocus, but after the message displays and enter is hit for the ok the cursor jumps to the DEPARTMENT_NAME on the current line. Is there a way to get the SetFocus to work properly on repeating items like this? I can never seem to get them to perform the same as they do on non-repeating items.

Thanks for your help.

HERE'S THE EXACT CODE:
If IsNumeric(DEPARTMENT_NBR) = False Then
If DEPARTMENT_NBR <> "00" Then
MsgBox "DEPARTMENT NUMBER must between 01 and 99.", vbOKOnly
DEPARTMENT_NBR.SetFocus
GoTo DEPARTMENT_NBR_EXIT (exits the paragraph skipping other checks)
End If
End If

Also, is there a way to look at a specific item in a list like that? IE. I want to reference the 3rd row's DEPARTMENT_NBR. Thanks.

View 4 Replies View Related

General :: Date Picker - Deduct 1 From Total Number Of Item On Stock

Jul 30, 2012

I'm creating s simple database to track my printer toner supplies, what i want is that..every time I select a date (using date picker) it will automatically deduct 1 from the total number of toners on stock. Right now, i have to input 1 in a field and it will update the remaining toners.

View 1 Replies View Related

General :: Check Box That Changes Value In Combo Box

Sep 3, 2013

I have a form with a combo box (it has two states (In process / On file)) and a checkbox and I need that when the checkbox is checked, change the status of the combo box..The combobox and checkbox are in different tables (Assigned and Movements, respectively) and refer to different types of data.

The checkbox Refers to a set of tasks FINISHED, then, if that's the case, They must change the values ​​of the ComboBox That has two values ​​or options (In process / On file). Note: These two values ​​are searched fields in a table "Status", and searches for values ​​in a table with the wizard searches

For example: While ComboBox contained in "In Process", the checkbox is unchecked and if this "On File" checkbox is marked.

View 8 Replies View Related

General :: Auto-populate With Check Box

Nov 20, 2013

I have limited Access experience, but have designed a database that we use here at work. In one of the forms for this database, there is a field where a distribution statement can be added manually, if the statement is received from a customer. However, we would like to add a "check-box" to the form, where is it is checked, the distribution statement automatically populates with a previously used generic distribution statement.

View 1 Replies View Related

General :: Check If File Exists?

Nov 27, 2013

I have a table with several thousand records. Each record as a path field that indicates a specific file that is associated with a given record (not just a directory, it identifies a specific file). I'm pretty sure that most of them are correct but I've seen and been cleaning up paths that have had typos in them or were otherwise not setup correctly. Is there a way that I can generate a report or a list of some sort that would tell me exactly which file paths exist and which ones don't? or even just the ones that don't.

View 4 Replies View Related

General :: Check Users References

Jun 26, 2014

i am having issues with certain users re references, I get weird errors when sending emails through Outlook, is there anyway running some code for me to check a users references?the below is what i have and everything works fine, so would like to check they have these

Visual Basic For Applications
Microsoft Access 14.0 Object Libary
OLE Automation
Microsoft Outlook 14.0 Object Libary
Microsoft Office 14.0 Access Database Engine Object
Microsoft Office 14.0 Object Libary
Mictosoft ActiveX Data Objects 2.5 Libary
Microsoft Excel 14.0 Object Libery
Microsoft visual Basic for Applications Extensibility 5.3
Redemption Outlook and MAPI Com Libary
Windows Script Host Object Model

View 1 Replies View Related

General :: Check Time Does Not Overlap

Feb 19, 2013

in my form i want to check if the appointment does not overlap another appointment.the appointment is made up of items that all have an individual time allocated.i thought of doing something like this but i am useless with syntax etc.

PHP Code:

if DSum("[TreatmentTime]", tblOrdersItems, OrderID " = & " "[Forms].[frmNewAppointment].[OrderID]") + "[Forms]![frmNewAppointment]![OrderTime]" > 'any record' tblOrdersItems.StartTime where StartDate = frmNewAppointment.OrderDate and 
Employee = frmAppointmentTreatmentItems.Employee 

then the only thing is that i dont know if it will work. it does in my head.

TreatmentTime = Time Field
OrderID = Foreign Key Field
OrderTime = TimeField
StartDate = Date Field
Employee = Foreign Key Field

the table is a one to many (parent/child). the OrderID is the parent. i have used a DSum to calculate the duration and the '+' is to add the start time to the duration which should leave the finish time. then the second part '>' to see if it is greater than any other start time.in my theory this will work but i dont know if access will search all records that have the same date.

View 14 Replies View Related

General :: How To Check The Record Count

Sep 11, 2014

1) If I check recordcount without move rst to last position I get wrong number of recordcount.

Code:

rst = CurrentDb.OpenRecordset(strSQL)
msgbox nz(rst.RecordCount, 0)

2) If I move rst to last position, number of recordcount is correct, but! If there's no record in my string I get an error that rst can't move to last position.

Code:
rst = CurrentDb.OpenRecordset(strSQL)
rst.MoveLast
msgbox nz(rst.RecordCount, 0)

how to check correctly RecordCount even if my query in string has no record?

View 5 Replies View Related

General :: How To Check The Record-count

Apr 3, 2015

1) If I check recordcount without move rst to last position I get wrong number of recordcount.

Code:
rst = CurrentDb.OpenRecordset(strSQL)
msgbox nz(rst.RecordCount, 0)

2) If I move rst to last position, number of recordcount is correct, but! If there's no record in my string I get an error that rst can't move to last position

Code:
rst = CurrentDb.OpenRecordset(strSQL)
rst.MoveLast
msgbox nz(rst.RecordCount, 0)

So the question is, how to check correctly RecordCount even if my query in string has no record?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved