Hello All,
I have made a critical error with my system, in tools on startup i unticked all the boxes, and now when it loads it brings up the system only and not the design view tables etc,
Is there anyway that this can be undone??????
goldstar
Last Activity: Mar 23 '08, 01:18 AM
Joined: Jan 26 '08
Location:
-
Locked Out of My Own Databse
-
Thanks
That would be much appreciated!!!! -
im still having issues with the information provided, would you have an example of thisLeave a comment:
-
Delete
Hello All,
Currently i have a transaction list form which displays all the transactions which have been saved.
If the client no longer requires the order, there is a remove button which would delete this: see code below
This works fine,it deletes all the items within the listbox and client details but i want it to update the stock levels for all the items within the listbox when remiove is prssed.
Would... -
i have an Items Table - which contains item details and stock levels
Itemhire table - item ordered, stock (from the items table) and quantity (this is the amount which the client selects)
Ive had a look and tried working with what you have produced but it still does not like it.
Would you have a sample of this?
All this help is much appreciated... ThanksLeave a comment:
-
sorry but my english is not as good....
lets try again.
I have an item table, hire table and item hire table
When an order is placed, the client will select the item and the quantity they require. When selected ok this will display that item within a listbox and into the itemhire table. The quantity they have selected would be decremented from the item table.
If the client then selects another item...Leave a comment:
-
Thank you stewart the information provided is really useful.
By the way would you have a solution to my other query which was posted, http://www.thescripts. com/forum/thread780473.ht ml
ThanksLeave a comment:
-
Changing or editing
Hello All,
Im struggling to get this idea and work out how to go about solving this issue.
What i want to happen is when a item is ordered and quantity selected, it is placed into a listbox, this quantity is removed from the item table. Then if the item is edited, for example if a total of 2 is selected first then it is edited to say 4, what i want it do to is remove another two from the order table. Or the other way... -
It still brings up an error, i think because it is a composite key, it requires something to be in both the fieldsLeave a comment:
-
Next Hireno
Just a quick query, currently i have an hire form, when the form is opened the next hireno would automatically be displayed within this box. This works fine if i already have an order stored. But if i was to clear the hire table, so no hires are currently saved, i would like 1 to be displayed within the textbox when opened. but a message appears saying, no current record.
This is what i am using
...Code:Set rsitem = currentDatabase.OpenRecordset("tblhire") -
Ok,
I currently have a system which allows hiring of items. When an item is selected this is displayed within a listbox and saved within a table. If i was to press remove then this would clear the listbox, delete from the table and update the hired item within the item table.
Currenttly say i placed an hire order for 10 items, these would all display within a listbox, then if the remove button was to be pressed, all...Leave a comment:
-
all items
Hello All,
Just got a quick query well im hoping it is a quick one!
What i am trying to do is update records with an item table when it is removed. At the moment what is happening is if i have say 10 items and the remove button is pressed it is deleting all the records within that hire , which is fine, I can also get it to update the first item within the listbox. But it does update the other items that were within the... -
Hi I have resolved this issue now it is picking up the hireline with no problem........Leave a comment:
-
Thanks for all the info it helped me resolve that, a bit late response, too much things going on at once....
but im getting another too few parameters expected 1 but this time i have used brackets, i like using this method as i feel comfortable and with not much experience it gets me through. any help would be appreciated
dbase.Execute ("UPDATE tblitem SET isselected = False WHERE hireno = '" &...Leave a comment:
-
Stock
Hello All,
I Have a remove button when selected it deletes an itemline of the hire order.
When a item has been removed, the stock should update on the item table.
Currently i could remove the item and update the stock but cannot get it to match for the same item within the item table.
so if any item had been removed it updates the first item in the item table
This is what i am using
Set... -
Hi again,
That didnt work, i tried doing it seperatltey see below
Data Mismatch error appears highlighting the second of the two.Code:CurrentDb.Execute ("Delete * from tblitemhire Where tblitemhire.itemno=" & Forms!frmtransactionlist!txtitemno) CurrentDb.Execute ("Delete * from tblhire Where tblhire.itemno=" & Forms!frmtransactionlist!txtitemno)Leave a comment:
-
Delete
Hello All,
Just a quick query, i have two tables, one contains the list of items in each hire and the other table the client details etc with regards to that order.
I have a transaction list form where all the transactions that are placed will appear.
If the transaction for a certain order is deleted i want the details for that hire to be deleted from both tables.
This is what i have been trying but it... -
Hi
I have placed a bracket and the end of the open recordset but the same error remains...Leave a comment:
-
Too few parameters expected 1
I currently have a listbox in one of my forms, when selected and delete is pressed i wish to delete this item from the list .
This is what i have been trying
[CODE=vb] If MsgBox("Would you like to delete?", vbYesNo, "Confirmati on") = vbYes Then
Set rstDeleteorderl ibe = CurrentDb.OpenR ecordset("SELEC T * FROM tblorderlist WHERE productID = " & 1stlistbox
rstDelete.Delet e
... -
Hello All,
The code above works fine, Is there a way to attach a button incase the employee was to forget their password,
I am currently trying to have a button on my home form saying 'forgot password'
When this is pressed a list of questions appear within a combo box and when an answer has been entered, they are logged into the menu form?
RegardsLeave a comment:
No activity results to display
Leave a comment: