Hi peeps. I created a switchboard that opens a form in add mode. I click the button to open the form, it appears, but with no data - its blank.
If I open the form by itself (not via switchboard) its all there.
Whats up?
Help!
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.
Has anyone had this happen?
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".
Hi All,
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.
Help please anyone, its been doing my head in.
Cheers
K
Hi all,
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?
any help would be greatly appreciated!!
Thanks in advance.....
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 !!!
Hello,
I have a form that utilizes a combo box called cboProgAddr (for Program Address). The cbox has 5 columns each of which fills in an adjacent text box. Since I needed the option of making corrections to these text boxes once they were filled in I need to set them up as unbound via the following code in the After Update event of cboProgAddr:
Private Sub cboProgAddr_AfterUpdate()
Me!txtProgStreet.Value = Me!cboProgAddr.Column(1)
Me!txtLocStreet.Value = Me!cboProgAddr.Column(1)
Me!txtProgCitySt.Value = Me!cboProgAddr.Column(2)
Me!txtLocCitySt.Value = Me!cboProgAddr.Column(2)
Me!txtProgZip.Value = Me!cboProgAddr.Column(3)
Me!txtLocZip.Value = Me!cboProgAddr.Column(3)
End Sub
As you can see it puts each field of data into two separate text boxes. Here's the issue: If I have to go back to the form after the original data entry the following boxes are blank...
txtProgStreet
txtProgCitySt
txtProgZip
while the following retain the orginal data...
txtLocStreet
txtLocCitySt
txtLocProgZip
The original cboProgAddr maintains its original data. All six fields above are stored in the same table as text field. I'd like all the boxes to maintain the data from the original input.
I'm totally baffled why this is so. I've attached images of the combo box control functions if that helps.
Thanks,
David
I work with an Access 2007 database that I split into a front end and back end. The back end holds all of the tables and the front end holds the queries, forms and reports. It is also a multi-user database, in that we have 14 people having access to the same back end. Each of the 14 people have their own front end. I have one main table in the back end listing clients and their individual ID numbers. That table has a One to Many relationship with several other tables, such as Case Notes and Authorizations, to name a couple.
Here's one of my problems: Sometimes data that is entered by a user will disappear.
Example 1: User creates a new record in the Authorizations form. Sometimes it is created by duplicating an existing record, sometimes it is completely new. User then prints a report from that new record, which looks like it has been saved. A couple minutes later, or a couple hours later, or maybe even the next day, user goes back into the database and cannot find the record that was previously created. At that time I look in the back end and cannot find the record either.
Example 2: User creates a new record in the Case Notes form on Day 1. These are always completely new records. User returns to the database on Day 2 and the new record sometimes does not show up in the form or in the back end table.
I cannot MAKE these things happen and they are sporadic, which makes it hard to diagnose, but why this was happening or if there was a way to retrieve the lost data.
I was wondering if it was possible to do this, currently if I need to add a new record, I have to add it all in the tables section, this works fine but would be easier if it could be done through the switchoard somehow.
View 4 Replies View RelatedI maintain a shared database that I would like other users to be able to see when the data was last updated when they open it so that they can see how up to date the information is from the switchboard.
Currently I am doing this manually by updating the date in a label on the switchboard header, but ideally I would like to add a final action to my update macro (that imports new data into the database) that would automatically do this for me on completion if possible.
I have created a switchboard 'front page' through which I hope for users to access the forms for inputting data.
Within this front page I have an 'enter' button - successfully created - everything.
However, I am unclear as to how you activate this, or any other button. I have linked it to the appropriate form and stated the action I want it to undertake, but nothing is happening.
What further instructions do I need to provide ...and where?!
I have a very large Access application and use a hidden "main switchboard" to store data such as the current customer ID. Prior to the advent of tempvars, I embedded a key control into many query's underlying combo boxes, list boxes and forms criteria:
"Forms![main switchboard]![currentcustomerid].
The problem arises when the user quits the application on with forms using this in their underlying query(ies). As far as I can tell, the application closes forms in the order in which they were opened, so the "main switchboard" closes first. Then, for some reason, the current form has a requery and the user is presented with a prompt to enter the parameter "forms![main switchboard]![currentcustomerid]. I tested and found I could replace the criteria reference to a tempvar to "fix" the problem. I wonder if there would be a way to open every query in design view and do a search and replace on the criteria statement.
I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.
I have the original database with the name of "Cell MFG Screen" that contains a switchboard. I am now creating a db to keep track of manufacturing waste (which will also be on the same server when completed). That switchboard is called "Cell Waste Weight". Again, I want to keep these db's separated from one another as well being able to add future dbs. Now, what my plan is to make up a one db that consists of only a switchboard that will be used as the main switchboard to be able to navigate to other dbs that are located on the server.
Does anyone know how this is done?
Thank you in advance for your help,
~Kilch
Hello,
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.
any help really appreciated.
Thanks
Eleanor
Good Day Everyone :)
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!
~ N' Take Care ~
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.
ANY ideas??:mad:
Hi All,
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.
Any suggestions?
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?
Thanks for your help!!!!
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.
ANy ideas appreciated on any of this stuff
Using Access 2002 and Windows XP
hi,
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.
my form is based on this
SELECT [JobRecords Query].JobReference, [JobRecords Query].InvoiceDate, [JobRecords Query].ContactRef, [JobRecords Query].JobDescription, [JobRecords Query].AuthNo, [JobRecords Query].AuthName, [JobRecords Query].OrderDate, [JobRecords Query].CompletionDate, [JobRecords Query].NettPayment, [JobRecords Query].VAT, [JobRecords Query].Total, [JobRecords Query].Invoiced, [JobRecords Query].Paid, [JobRecords Query].IncomeRef, Customer.DrawerRef, Customer.CustomerName, Customer.CustomerAddress, Customer.[CustomerPhone 1], Customer.[CustomerFax 1] FROM Customer INNER JOIN [JobRecords Query] ON Customer.ContactRef=[JobRecords Query].ContactRef;
can anyone help?
thanks
Barrie
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.
Today it seems that changes I am making to a form within a Navigation form are disappearing.
If I make the same changes to the underlying/original form, they are also disappearing.
Hi all,
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.
Tom W.
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.
Many Thanks in advance
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!?
View 1 Replies View Related