i have tables called JobRecords and Customer, JobRecords contains 10,000 invoices (jobnumber 1-10000, but all are blank) these 2 tables are related by ContactRef. the idea is to select the ContactRef when entering an invoice and it will automatically fill in the address, phone number fields etc from the Customer table.
now since i need a VAT and Total values, i used a JobRecords Query, when creating the entries i had the default value for ContactRef set to (select) which in the Customer table has N/A values for all fields. my form shows all invoices with data from the jobRecords Query and Customer table, so when i added some new contacts into the Customer table, and then changed some of the invoices to show these addresses instead of (select) and N/A, they disappear.
i know that if some of the fields are null then it wont show the entire entry but even making sure all fields have data in it, it still doesnt appear in form view. it doesnt dissapear in the JobRecords Query either only the form.
I have a main form and on my main form i have a button to open a popup form. very simple docmd.openform statement. This is an unbound form that lets user filter and select some data to populate the main form.
My problem: When i update code in the form and reopen it (via button or navigation pane) i cant see it. I know its open but i cant see it. If i change popup-no then it opens and i can see it, if i change back to popup-yes, i cant see it again. The problem only happens after i open VBE for this form. I've been importing older versions of the form, opening VBE and the phenomenon occurs everytime.
I have a table in access which is updated weekly; I need to create two tables from this updated table.
1st table will consist of all the new entries for the current week
2nd table will consist of all the entries from the previous week - an amalgamation of all the entries which are not from the "current week" (table) For example; the table below shows the two entries from last week.
ID Name
1 Adam
2 Ben
This week I have three new entries New entries
ID Name
3 Charles
4 Richard
So when I run the same query next week I will get something like this.
Old Entries ID Name
1 Adam
2 Ben
3 Charles
4 Richard
[code]....
How do I get a query /queries which divides up the weeks new entries and also all the old entries.
I have read a couple of other queries about this problem, but none seem to help me. I have a database, not too large (c.2000 records), not too complicated (very few macros, no referential integrity, no reports or subforms, mainly simple queries). Over the past few weeks records have started disappearing. Vanishing, no trace. No pattern to the record numbers. About 220 in all have disappeared so far. There is a main table (manuscripts), with links to other tables (manuscript notes, manuscript decisions). The records disappear from the manuscripts table, but the related records are left in the other tables. Only five people use the database, no one has deliberately deleted anything in fact as we keep all information.
Could this be a virus? I cannot believe that the database is too large.
I am in a dilly of a pickle here: after i set up my form all nice nice, with cascading combo boxes, other random combo boxes, a search button, setting up the SQL, etc. I was so proud- thinking i've finally done it! :) But then... as I reloaded the access form afterwards it only displayed in design views and SQL views, and not the other view. :eek: :confused: So, this being my first ever database, I have no idea what the problem is. I have checked the properties box, and it is not a problem with the settings -not - being on display always, nor with the other property settings. (I believe)
Any advice/input would be greatly appreciated into this matter :) Thanks a million in advance!
I have a combo box on a form, this combo box by the use of a select query shows all the relevant values in the drop down box from a table:mad.
My major problem appears to be that records that are selected in the combo box by way of the slect query seem to be disappearing from the table or part of the record is lost.
I have a large database with about 200 queries. I am having a problem with the last few I added. I run them from VB. When I run them the SQL statement disappears, sometimes. If I go to the SQL View instead of the Design veiw all that is left is Select;. I the Design View there is nothing.
I have a form that has a memo field. If text in the memo field is highlighted and I press the enter key the text is deleted.
Does anyone know how to prevent this from happening?
I know it is easy enough to click off the text (deselect it) so that pressing the enter key will move me to the next field (as required) but I don't always remember to do this and Hey Presto I've lost my text and have to start again.
But why highlight the text in the first place I hear you say. Well I have just pasted it in from a different application and it comes in highlighted.
I created a new DB and there are times when I open my form that all of my entry fields have disappeared along with their captions. Sometimes I am able to advance through different records and get the fields to reappear, otherwise I have to close the form and reopen it. What causes this and is there something I can do to prevent it?
I have a form with an unbound subform that was working quite nicely. The only change I made was changing the data source for the main form from a query to a static table; name of table same as the prior query. Now the subform appears but the data doesn't. The buttons in the subform header are visible and work but the detail is not visible when displayed as a subform, it is fine if I open the subform as a separate form, I see the correct records based on the main form's criteria.
I have searched for some property I may have accidentally changed but can't find anything. It isn't set in data entry mode, not even a blank line shows.
I have been experiencing some very strange symptoms over the past week or so, and am looking for ideas. I have a number of different frontends that link to one or more shared backends. A week or so ago, all the frontends were reporting that one of the backends, PCAMaster_be, was corrupt (ie, "not a recognizable database format). I repaired it, it worked ok, and then a few hours later it was corrupted again. After going through this a few times, I rebuilt the be (imported everything into a new, blank db). Same thing -- it was OK for awhile, then became re-corrupted.
So, my conclusion was that: a) one of my frontends was corrupting it,or b) my shared library.mde file was the culprit, or c) my shared .mdw file was the culprit.
I have been meaning to unsecure my db's for awhile becuase I don't really use the security in any meaningful way. So, spent most of the day yesterday going through the steps to unsecure. So, I'm not using anything but the default .mdw file now. I also rebuilt every single FE, BE, and the library.mde.
Now, PCAMaster hasn't gone corrupt again (yet), but I'm noticing several other bothersome symptoms:
1. In one of my FE's, when I close it, the application closes but it leaves Access running. I have to use task manager to get access to close.
2. Some of my .ldb files seem to stick around when they're not supposed to. I am 100% certain that NO ONE is using the db. But the .ldb file is still there and I can't make it go away.
3. I open a FE with the /excl command line option. It opens OK, but when I try to repair/compact, it won't let me. ANd if I try to make design changes, it says I don't have exclusive access.
I have a form called CreatePL which is made up solely on List Boxes that the user must choose from. After all the choices are made, I have a button to save the information to a table called PL.
I noticed that after clicking on this button, that record stays active so when you try to create the next record, it is actually changing the previous record. As I was testing this a bit further, I also noticed that the one of the names in one of the list boxes got erased (I'm not sure how yet).
Is there a way to lock the information but still be able to make selections and save it to a table? When I choose the properties so that you can't edit, I loose the ability to make choices also. All of the list boxes are set to "limittolist".
I've got a form with a series of combo boxes which are dependent on each other, however i keep finding that after ive entered some data and left a record, when i then return to the record, some of the information ive entered has been deleted and the combo box is blank.
I think it must be requerying the combo boxes everytime the record opens but i dont know why, i have only put requerys "OnChange" because that is the only time the dependent combo boxes should be requeried.
Once the info is entered and ive moved on to a new record, i need for it to stay that way when i return to the record and only change again when i edit it.
I have two forms "Enter_details" and "sendemail" on typing txt in "enter_details" forms txt field " checksum" i want it to be updated in "BODY" field of "Sendemail" "SendEmail" form may be open or may not be open. I put this code on "Sendemail" but its not working plz help
Private Sub txtBody_BeforeUpdate(Cancel As Integer) [txtBody] = Forms!Enter_Release_details.[Checksum] End Sub
I think I have this figured out, but wanted to see if anyone else had run into the same thing.
I keep each of my client's databases in separate folders named after their respective company. One of them has an apostrophe in the name and I have it named that way and have never had a problem with it. I had copied a front and back end mdb from their office and reloaded it on my computer to make some changes and got a strange error. When I went to check the relationships, there were none. I checked a previous copy of the program and the relationships were all showing correctly. I went back to their office and got another copy of the program, copied it back to a temp folder on their computer and found that the relationships were ok. But when I loaded the files here, they weren't there.
In the end, it was the apostrophe in the folder name that caused the problem and it occurred to me that Windows had updated the other day. Has anyone else had this happen? I guess I learned another lesson about naming anyway.
Hi, I've searched through the archives and cant seem to find an answer to my problem - hopefully someone may be able to shed some light on this for me as it is driving me mad!
One table in my database keeps getting corrupt records; I get various error messages when navigating a particular form - including 'Record is deleted' (when it hasnt been), 'The search key was not found in any record, 'Object invalid and no longer set' etc. After receiving one of these messages one or more records in my table corrupts (strange symbols and #Error# appears in the fields) - I have to compact and repair and delete the record.
I have imported everything into a new clean database several times but the same thing keeps happening.
Additionally the table that keeps corrupting is randomly 'losing' its primary key and relationships - they just simply dont exist anymore. I understand that importing into a new database could cause this - but they arent disappearing after I have imported; the database can be running fine and then after a few days I check the table again and the primary key is no longer set and the relationships to other tables have disappeared.
I am compacting and repairing every day and having to recreate a new clean database about once a week - and keep getting the same problems with the same table!!!
Has anyone seen this happen before and could anyone suggest where I would begin trying to resolve this. Any advice would be REALLY appreciated.
I apologize if I'm missing something terribly simple.
Here's the background: I have a set of 3 tables linked to a main table based on a field called SampleID. I then have one main form (SAMPLE) with the other 3 tables (INDIVIDUAL, LOCATION & ORGANISM) all as subforms within the main form.
everything seems to work well in terms of links and getting the data into the appropriate tables and retaining the SampleID link. However, during data entry using the tab key, I am unable to find an eloquent way to move from the main form to subform1, then from subform1 to subform2, from subform2 back to main etc. I have set the tab order, and used the afterupdate control to change the focus which works, however as soon as I move from subform1 to subform2, the data just entered disappears from subform1. The data makes it to the table without any problem, but just blanks out the form.
From what I can see, when the subform loses focus it automatically saves the edited record and inserts a new record, thereby blanking out the fields that were just entered. Is there a property that can be set so that a new record is not automatically entered when leaving a subform? Is there a method to do this through coding?
I cant get the report the way i want it anyway but basically i have a subreport header embedded in the Page Header of my report.I can see it in Report view but not in Print preview and it does not print of course!?
I have [Product] in Orders Table and Orders Form as Combo Box for showing Product from Products Table.
And within product field on Orders, I want to make 'Active' product only showing up when choosing from combo box.
I made some records to test in Orders Form. Then I filtered Product from Orders Form with query:
Code: SELECT Products.ID, Products.Product, Products.Active FROM Products WHERE (((Products.Active) Like Yes)); Then I changed some product 'Active' to "No" And the old record disappearing.
How to make older record not disappearing when I filter some of field not being available to choose (because Active product uncheck)
I have table with different companies and related info. Another table with contacts for each of the companies, each company might have different number of contacts. I want the form to show all the contacts for each of the company, if there are two contacts in the company then show two, if five then show five. Just to make sure I am doing it the right way, what is the best way to build a form that is based on multiple tables. Thanks in advance, John
I'm trying to build a Form that will allow one field to be automatically populated when data is entered in another field. I have a table that contains two Fields: Course Name and Course Code. When I enter the Course Name in a Form, I would like the corresponding Course Code to appear in the relevant box on the Form.
Can anybody point me in the right direction as to how this can be achieved
Good morning, I am experiencing an extremely strange problem that I will try to explain here...
I have got a subform which goal is only to display a few fields from a database. Not any interaction is made from mother forms, it just displays data, and that's all. It is really simple, and has been created with a wizard.
One of the fields, that is named OrderPart, has got for values either True or False. Most of the times, I don't have any problem, but, only when all the OrderPart fields are set to false, nothing is displayed anymore on the form, like if everything were hidden.
And if I change only one of these values to true, all other rows reappear, including those with the OrderPart field set to false.
The query to get the data is: SELECT subparts.* FROM subparts WHERE (((subparts.repairno)=[forms]![subpart assignment]![reportno])); . Moreover, when I run it outside the form, it always displays all information.
I don't have any filter, my request selects all objects, and I don't have any code, so I absolutely don't understand how this may happen! So if somebody should have a little clue, it should be very nice, thank you very much :D !!!
I have been trying to move some of my employer's database information from Excel to Access. The fields are simple stuff, first name, last name, address, etc. My only problem is the Amount Owed section in which I would have to put amounts such as 1270.70. In Access, I formatted the field as currency with 2 decimal places. Thus, it shows up as $1270.70 in the Access database.
However, when I mail merge the field to the letter, I only see 1270.7. I could not seem to make that last 0 appear. How could I make the 0 appear?
Further, as I have said, I have been moving records from Excel to Access. For mail merge purposes, would you recommend Excel or Access?
My goal is to use a combo box on a nav pane to filter the following 5 nav panes with data sheet views on them. The combo shows 'component' and should filter each datasheet to only show records with the same 'component' selected in its respective component column.
What I'm currently dealing with is said component combo disappearing upon nav change, and I can't get it to filter the datasheet..but that is likely due to the fact that I cant get it to hold value on page switch.
