Database Contents GONE!?!?
Jul 26, 2005
I go to open my Access 2000 database this morning and the contents: tables, queries, forms, reports, macros...all gone! The database file is still there, and when I go to view it's properties, I verified that it is the database that I created back in April and not somebody that overwrote my database using the same filename.
Is there any technical explanation as to how this could have happened? Or is it undoubtedly the result of human intervention?
I placed it on a network drive here at work.
I kept a copy thank god, but the copy is a couple weeks old and I'll lose alot of recent data. I've put in a request to have them restore the file from when it was last used Friday.
Just wondering what could have happened so I can prevent this from happening again.
Thanks!
View Replies
ADVERTISEMENT
Nov 14, 2006
Hello all,
I had just created a startup screen which I wanted my access database
application to open automatically in.
On the tools menu I selected the startup option and specified the file I
wanted to appear in the startup. I used a form for this but noticed that a
forward and backwards navigation box appeared on this form, which I didn't
want. As such I went back into the startup option and unselected all the
checkboxes (hoping that one of them might correspond to the navigation box - I didn't reallt read them). I then closed down the database and opend it up again.
However, now, upon starting I only get the startup form I specified, and when
I close it I can't see my other forms and tables anywhere? I want to undo my
actions but only File Window and Help are available in the menu bar above.
Arrggghhh!!!!. I've searched for them everywhere but they all seem gone? Seems like a disaster.
Any help on recovering my work would be greatly appreciated.
thanks
Adam
View 3 Replies
View Related
Jul 14, 2006
Hi,
I'm making a form where the contents of a field is determined on the contents of another field in another form. I thought an IIF function would work, but when I tried it the contents says #NAME.
I put it in the control source.
IIF([Forms]![Frm_NewBusiness]![Page4]![Child51]="NTU",NewBusiness_Date_Issued="NTU",NewBusiness_Date_Issued)
Any ideas?
Cheers,
Ben
View 1 Replies
View Related
Jan 21, 2007
sorry for the title. i didnt know what to write.
this is the situation:
i have a form where it populates a table in access (ssmdata) from an oracle table w_ssm_data). this works perfectly.
Then the form read the hole new table in access (ssmdata) to update a specific field.
Problem:
If i open the access table (ssmdata) it is sorted by the flight fields. However, when the form reads the table in order to update the specific field the table seems to not to be sorted by the flight field.
More info:
The ssmdata table in access has many primary keys (flight, departure,arrival,caterer,frequency and aircraft).
If i take a look to the W_ssm_data table in oracle it is not sorted by flight and it is sorted in the same way the form is reading the ssmdata table in access.
example:
table in access:
flight dep arr caterer aircraft frequency
1 a b a 111 67
1 a b a 222 134
2 c s c 111 5
table in oracle:
flight dep arr caterer aircraft frequency
2 c s c 111 5
1 a b a 111 67
65 t h t 252 1
when the update step starts it reads the access table as it looks in oracle. but if i open the table in access it looks sorted by flight.
thx 4 your hlp again, max
View 3 Replies
View Related
Mar 10, 2006
I have a new job at a company that had someone else develop their Access application. My boss has asked me to print out all of the options in several comboboxes so he can have me either add to or delete some of the items in the list.
Is there a way I can copy all of the items in the list of a combobox? :confused: These comboboxes are not bound to any tables.
I hope I have explained this well enough for everyone to understand what I am asking.
Thank you in advance for your help.
View 2 Replies
View Related
Jul 13, 2007
Does anyone know if it's possible to edit the contents of the "Enter Parameter Value" Box...for starters, I'd like to delete the phrase "Please Enter Parameter Value" as it means nothing to most users of Access; also, I'd like to format the text that I've entered in the query itself, i.e. make it bold, increase the size of it.
Incidentally, I did go down the route of linking my query to a form but this caused problems as I want more that one user to be able to view their particular parameter value at the same time.
Many thanks
View 13 Replies
View Related
Jan 12, 2005
Hi.
I have created a database for an old office filing system in work.
There are 2 tables – Files & File Contents.
Table ‘Files’ has 5 fields: ID; Number (e.g. 1/03); Title; Status (e.g. Live/Closed – created a list on the relevant form using the Lookup wizard when creating the table) and Referenced To – at some point in the future all these files will be closed and this last field will show what all future correspondence is filed on.
Table ‘File Contents’ basically lists all correspondence on every file. But, some of the files have categories exclusive to them.
In the form ‘File Contents’ if someone was inputting new correspondence I would like the category lists to show just the relevant category for that file, i.e. if File 1/03 Training is selected then the 3 Training Categories will show and if File 5/03 is selected then the 2 categories relevant to it are shown.
But I don’t know how to do that…..
Should I create new tables for each of the ‘Files’ showing the categories or would one category table do?
I would be grateful of any help/advice you can give me.
Thanks.
Philip
View 1 Replies
View Related
May 18, 2005
Hi,
I am trying to copy the contents of a table with 11 fields into a new table which is the same except for an additional two fields at the end.
Any advice would be appreciated..
Thanks..
View 2 Replies
View Related
Oct 5, 2007
I have two tables that have the exact same structure. They both started with the same data, but each were changed separately. (Two copies of the same DB, editted separately). I need to review the data in each record and determine what has changed or if records have been added. Is there an easy way for me to do this? (Note: Each record does have a primary key)
View 1 Replies
View Related
Aug 27, 2007
Greetings to All,
I have one table (tblLink) that resides on an SQL Server quite a distance from me. I have another table (tblLink_r) that resides in a local .mdb file. The tables are identical except for the data they contain and where they are located. Only one index (LinkIdx=autonumber) exists. I am making sure there are no duplicate indicies in the LinkIdx fields because I started the LinkIdx field in tblLink_r at 2100000000.
When I open tblLink (remote), I can scroll to the end of the 21,000 records relatively quickly - read: little latency. Queries performed on this table similarly show little latency.
When I open tblLink_r, I also have little latency. This table has 100 records.
I need a single object which contains the contents of tblLink and tblLink_r. I have tried a UNION ALL, but this query takes upwards of 4 minutes to complete which I can't understand since either of the constituent tables only take ~.5 seconds to call up.
I am hoping someone can provide a way to speed up the UNION ALL query or provide an alternate means to combine the contents of these tables.
View 2 Replies
View Related
Jan 30, 2006
I have a combo box whose row source comes from a table. I want ppl to be able to select from the combo box but I don't want them to be able to make any changes to its content (in the table).
How do I do that? I've fiddled around with the Lock features in the forms but I cannot get the right setting. Advice? thanks.
View 2 Replies
View Related
Mar 24, 2006
...seems such a simple thing to do but I'm completly stuck. Everything I've found on the forum suggests alternatives to doing to above i.e. setting the query that produces the list to produce that report print directly but that wont work for this situation unfortunately.:eek:
Some background....
I have a form (lucky me) in which the user enters 3 category levels and a branch id, they click a button to generate a list of 50 random stock ids so they can be checked at the branch. A preview of the Stockid's (along with description and Stocklevels) is shown in a list on the form. The stock manager then needs to print the list box contents. If the query is re-run it will differ from what is shown in the list so I need to avoid this.
Any help greatly appreciated.....;) :confused: ;)
View 2 Replies
View Related
Aug 3, 2006
I have a combo box on a form to enable users to find records. When the form opens initially, these boxes are blank. However, after a search has been performed, the selected information in the combo box stays there, as well as the record opening up. How can I make the combo box revert to being blank after the record has opened on the form?
Thanks in advance,
Gary
View 1 Replies
View Related
Sep 1, 2006
Is there a way to make the value of one field change dynamically based on the values in other fields on the form?
Here's the general idea. I have two tables.
RecordTable
--------------
SiteID, etc.
SiteTable
-------------
SiteID, SiteBlurb
I want have a form, where you can change the SiteID value in RecordTable, and have the SiteBlurb change (i.e. the form pulls the information from SiteTable) dynamically once you have entered the new value.
View 1 Replies
View Related
Oct 9, 2007
Hey guys,
I have created a list box that is based on a select statement using the value of another list box.
for example:
box1 lets you select aaaa
box2 shows a list of all the records that have aaaa
now I need to know how to clear the list as box1 is changed
right now it will give me
aaaa123
aaaa789
bbbb123
bbbb789
I need to know how to clear it so that
aaaa is deleted and bbbb shows when the code is stepped through a second time.
code is as follows:
Private Sub Car_Empty_GotFocus()
prefix_input = Form_Car_Loading.Prefix.Value
Set db = DBEngine.OpenDatabase blah, blah, blah
sqlstatement = "SELECT [prefix], [Car_number], [Date_loaded] " & _
" FROM Car_loading where isnull(Date_Loaded)= true and prefix= '" & prefix_input & "' "
Set record = db.OpenRecordset(sqlstatement, dbOpenSnapshot, dbSeeChanges)
Move first
Do Until record.EOF = True
Form_Car_Loading.Car_Empty.AddItem (record(0) & record(1))
record.MoveNext
Loop
db.Close
End Sub
View 1 Replies
View Related
Oct 23, 2011
Any way in MS Access to read the TOC data from an Audio CD? It is I believe in the lead-in part. I have a music database, and would like to be able to read the track data directly from the CD (Title, artist, timing), without having to type it all in again.
I know this can be done, because my CD labelling software extract the data automatically - but can Access do it?
View 3 Replies
View Related
May 8, 2014
I have some code to create a table of contents/index for a report which has "chapters" which can be added or dropped depending on whether we choose to stock something or not. And I'm getting the strangest issue. The very first "chapter" starts fine on Page 1. But the next item we sell (Chap 2), then starts on Page 3, instead of Page 2. Here's what's strange. Every other item is then one page off. Below is my code.
Code:
Option Compare Database
Dim db As Database
Dim TocTable As Recordset
Dim intPageCounter As Integer
Function InitToc()
'Called from the OnOpen property of the report.
[Code] ....
The InitToc fx is called upon the opening of the pricebook, the UpdateToc fx is called upon printing. There's something in here where I think I'm calling the functions incorrectly, but I'm not sure quite what the error is.
View 8 Replies
View Related
Jun 18, 2015
is there an alternative to making a field blank, other than my old trusty <Me.Field1 =""> ... ?
(my use of the < and > are purely for demonstration purposes, and do NOT get used in code)
I'd like some fields to be native, virgin, blank, et cetera... I do find sometimes I have to overly complicate a VBA statement by putting.. <If IsNull(Me.Field1) or Me.Field1 = "" then> because I have made that field value = "" to blank it out.
View 3 Replies
View Related
Apr 21, 2006
can anyone tell we how to send the data from a subform to word, using a button on the main form? I'm using access 97
View 1 Replies
View Related
May 26, 2005
I have a form that I would like to embed some text that is queried from the internet. I'd like to have a part of this form display this "quote of the day" info in a textbox, and im not sure how to do it.
The link to access the quote is through javascript:
<script language="JavaScript" src="http://www.quoteworld.org/quotes.js"></script>
Any ideas of how this might be accomplished?
Thank you,
BT
View 1 Replies
View Related
Feb 27, 2007
This may seem a very simple question, but I really don't know how to do it. Basically, I want to MessageBox contents of a table with a button. I have a table called Map, and has two fiels: Column Number and Description. When a button is pressed, then I want a messagebox to come up and show the column number and the description of a single field. Although I know it is very wrong, here is the code I used for this (r![column Number] = 4 is meant to be the forth column number in the table):
Dim d As Database
Set d = CurrentDb
Dim r As Recordset
Set r = d.OpenRecordset("Map")
r![column Number] = 4
MsgBox "Column No: " & r![column Number] & ". Description: " & (r![Description])
By the way, there are seperate buttons for seperate fields. It is DAO as well
Thanx in advance
View 6 Replies
View Related
Jan 11, 2007
My company requires a query to aid distribution, however I am experiencing some problems implementing the system.
We have purchased a large database of addresses and need to be able to query a town/street to find out how many houses are in that street.
I have the query and form set up to display the street/town and list of house numbers when searched for, however the houses are grouped by postcode rather than street, with multiple house numbers in the same field (see example).
Street
Main Avenue
POSTCODE
HG23 0DF
Houses
89;91;93
POSTCODE
HG23 1DF
Houses 95;97;98
----
Basically, I need a total of how many individual houses there are in a street, regardless of postcode. In this case, it should treat the ";"s as dividers and return the result of '6'. Or in some cases ignore the semicolons as some fields look like ";;;;;;;;13". It should then add both the total for one postcode to the other postcode to display a complete total of houses in one road.
Can anyone make any suggestions?
Thanks in advance,
Matt
View 1 Replies
View Related
Feb 21, 2008
HI
Is there a way that i can split the fields based on the delimiter that i will set in a query?...
for example : 088H-FJAKSDF-SAFN-F
in that case additional four columns will be added becuase it will be separated by a dash (-)
thanks so much for your help.
View 14 Replies
View Related
Apr 25, 2008
Hope this works, The table is as follows, ish
Name1 y/n1 y/n2 y/n3 y/n4 y/n5
a...........y......y....n.......n.....n
b...........n......n....y.......n.....y
c...........y......n....n.......n.....n
d...........n......n....n.......n.....y
e...........y......y....y.......n.....y
f............n......y....n.......y.....y
g...........y......y.....y......y.....y
what i need to be able to do is take a form/query answer some questions, y/n1= y/n2= y/n3= ......
Then off the back of this be able to pull out the correct item from column name1.
But i don't need an exact match on all columns. If i am only interested in y/n2=y i need to display all matches
My head says the following If y/n2=y and y/n3=y Then Name1 = e and g
or another example if y/n2=y and y/n4=y and yn5=y Then name1 = f and g
if a y appears in more columns it doesn't matter but it has to be in all those columns i am looking at
can anyone suggest the simplest way forward on this.
View 1 Replies
View Related
Mar 24, 2006
I have a repair database which I'm working on. On the main WIP form there is a subform stating the faults which have been logged against that unit. The unit can be scrapped at any time by hitting the SCRAP button, but if the unit has had it's faults successfully repaired, then it can then be FINALISED which means it can be shipped to the customer.
I need to be able to check the records in the subform, to look for faults which have not been repaired. When they are repaired, the text "PASS" will be present in the TEST_RESULT field. I want to be able to check the TEST_RESULT field for each fault to ensure they are all a PASS before I allow the unit to be FINALISED. Any ideas how I can do this? Or am I taking the wrong approach?
Thanks,
Gareth
View 10 Replies
View Related
Aug 18, 2006
Hello,
I'm a new Access user and i couldn't figured out how to implement the following:
- I've got a form with buttons on it. These buttons refer to different querries which either displays or changes specific data on the predefined table.
- With a text box (or another thing) I want the user to enter a table name, so that the querries gain portability to work table-independent.
Briefly this is what i want;
-- User should enter a text
-- This text should be used to change the TABLENAME in each of the querry
But I don't know how :(
Is there anyone who has time to explain this implementation in detail??
Thanks anyway..
View 3 Replies
View Related
