Hi,
I have a data entry form that is based on four tables which are linked by a field 'fileno'.
I am now trying to enter new records via the form and update the four tables but i'm not permitted to do so. It seems that all the fields are locked for display only.
Can anyone help?
Thanks
Will.
I created a form with a query as it's source. I am able to open the tables themselves and update them, but when I go to a field on the form I'm unable
to update. What could be wrong since I have full update rights to these tables? I've checked the properties and they appear to be set correctly.
I have a form which is based on a query which selects information from three different tables. All fields apart from one are locked, all are enabled. The table the field I wish to update is native to the current DB i.e. is not a linked table.
when I activate the form and try to click on the Check box, which is not locked, I get a beep but it does not change state.
I am using Access 2007 on win7 Pro.
Trying to update a field in a record in my form after selecting from a comboox.
This an orders form with a record per row for order items. I select the product from a dropdown list which is populated by a dynamic query from the afterupdate event on another combo. When I do the selection access reports the following error:
Runtime error 3331
to make changes to this field, first save the record
Debug takes me to the line :
Me!product_id = DLookup("product_id", "products_table", myvar)
from :
[code]
Private Sub comboProd_description_AfterUpdate()
Dim strFilter As Integer
comboProd_description.Value = comboProd_description.Column(1)
myvar = comboProd_description.Column(0)
Me!product_id = DLookup("product_id", "products_table", myvar)
[end code]
I'm lost as to what to do (no such thing as beginners luck!!). I'm not even sure if the error is from the combo box or from the field that it is trying to update (product_id)
Thx for looking
Kev.
I'm trying to have the user select an item from a combo box which gets its values from a table with multiple columns. Once something is selected in the combo box the form will auto-update the adjacent text box to a value in the same row (different column). The combo box is called 'Media' and the text box is called 'Tape Cost'. When you select a type of tape in the combo box the adjacent text box should populate a value determined by the second column of the table. Instead I'm getting a message that the, "Method or data member is not found" and it highlights the red text below.
Here is the code I'm using:
Private Sub Media_AfterUpdate()
Me.Tape Cost = Media.Column(2)
End Sub
Not sure what I'm doing wrong here. Thanks!
Hi,
I just created another query, but with this one I cannot change any of the data. What could be the reason?
Thanks
I have a form that displays an updatable subform. The main form has search fields and a search button that when clicked will reset the record source of the subform and then do a refresh. The problem is that after the search the subform stops becomes locked. Here is the code:-
Me!sbfDepartmentSub.Form.RecordSource = MySQL
Me.Refresh
I have tried Me.Requery also.
The main form in my database is giving me an error message to say "The form name is misspelled or refers to a form that doesn't exist" when I try to open it, despite the fact that I can see it there. If I try to change its name it says "save operation failed". Does anyone have any idea what this could be before I recreate the form?
Thanks very much for any help.
I have a form, containing a subform.
The form displays various fields for the user to enter order details.
The subform is populated with all previous deals for the person whose deal is being recorded. This subform is purely for display purposes and the data shown cannot be edited.
The problems I have are:
1) When a user clicks anywhere on the subform. They can tab through the fields or scroll around the subform without any problems. However, when they try to return to the main form, all controls on it appear to be locked.
2) Clicking on the subform removes focus from the main form, so saves the record being edited on the form. This is a big problem, as the order may be in error and/or incomplete. I only want the user to be able to save or cancel the record, using specific buttons on the main form.
Is there any property for the sub form I can set to prevent the above from happening?
Thanks in advance.
Hi all,
I'm having a problem here and after searching the web, I can't find a solution.
Problem is that I have a form which seems to be locked. None of the fields can be modified. This should be ok except for 1 combo-box.
I have checked all objects settings and all objects have:
Edit/Delete/Add options enabled;
Visible option enabled;
Locked option disabled;
The form has only Fromview enabled and recordlock is off.
There is no VB code modifying a 'locked' status.
Can someone help me out here?
My project is +20Mb so first I'd like to see if there are any things I've forgotten to check before I'll strip and post it.
I've posted this in the 'General' forum, but without success, so I'm trying here.
I have two databases. One is 'live', one is for development. Once I get something working in the latter, I manually import it into the former (File - Get External data - Import). This has been working fine for just over two months.
Today, however, i'm trying to import a form and get one of the following messages:
"The search key was not found in any Record"
"No current record"
I'm unable to import the form. I also get the same error messages if i try to copy and paste the form within its own database.
The form in question has a lot of lengthy code behind various combo boxes, text boxes, etc. When I attempt to look at this code (via right-clicking on a field and going to Properties and the Event tab), none of it is present any more.
What's going on? This form took weeks to get working and now it can't be copied, renamed or imported, plus it appears to have been 'wiped' of everything but the visual features.
Any ideas what could be causing this? Can one form become 'corrupt'? If so, please say that there's some way to remedy it?
I have a table, form and a query
Table structure
Project Name , Description , teamA(Yes/No Box), teamB (Yes/No Box), teamC (Yes/No Box)
Form namely search project by team
show three Yes /No box for selection
query
SELECT Projects.[Project Name],
Projects.[Project Description], Projects.[Project Category], Projects.[Start
Date], Projects.[Est Completion Date], Projects.[End Date], Projects.[Project
Benefits/ Impact], Projects.[IT Resource], Projects.[Key Participant], Projects.[Last Update/Comments],
Projects.[Action Owners], Projects.Status, Projects.Activity,
FROM Projects
WHERE (((Projects.[TeamA])=[Forms]![Search Project by Team]![TeamA]) AND ((Projects.[TeamB])=[Forms]![Search Project by Team]![TeamB]) AND ((Projects.[TeamC ])=[Forms]![Search Project by Team]![TeamC]))
it is zip file unable to get the size lower yet minimal amount in database I have 2 tables and one form when I create an query on the form the form then becomes that I cannot enter data in it or edit etc
View 3 Replies View RelatedI am trying to close a form with a subform.
I enter data in the main form and then the subform.
The main form has a save btn with an on click event which includes at the end of code
If Me.Dirty then
Me.Dirty = false
DoCmd.Close
DoCmd.OpenForm "FormName"
However the Form will only close and open the required form if I remove the two "Dirty" Code lines.
I am obviously trying to ensure that the data is saved on both the main and subforms using the If Me.Dirty......code
I am very new to MS Access. I have a main Form - ( Around 20 Projects - 20 Line Items).When I click on the Project Number - It opens a Task. Every Project will have multiple Tasks and when I click on Tasks it opens another form where I have to update the status depending upon the group.Now the problem here is when I click on the Tasks it opens the form but I am not able to save any data in that .When I close and come back all the data is gone.
View 14 Replies View RelatedI was updating my records by filling a form and entering the data's into a table but all of a sudden i couldn't add data to form and table..
View 9 Replies View RelatedI tried to follow the Allen Brown print the current record in the form and its not coming up. I can print all of the records but not the current.
View 3 Replies View RelatedWhy I cannot print a report using a single record in a form using Access 2007.
I have added the button, I am using the following code:
Private Sub cmdPrintRecord_Click()
Dim strReportName As String
Dim strCriteria As String
strReportName = "Receipt"
strCriteria = "[ID]='" & Me![ID] & "'"
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria
End Sub
However when I click the button nothing happens. I have attached the database ...
I am using the Contacts Entry form, and when I am on a record that someone has paid I want to be able to print from the Receipt report that has a simple formed up letter.
I have a form with 10 combo-boxes. Once user selects a value in CB1- CB2 becomes visible and active. I am trying to run a dynamic query- where the selection of the combo-box is used to select a column from my table called "dbo_animals"
To elaborate: CB1 contains the following values
Code : elephant, giraffe, bufffalo, tiger, lion
Once the user selects elephant in CB1, CB2 becomes active and I select tiger next. So the query becomes like. The process can go on and the user can select up to 10 animals
Code : **SELECT elephant, tiger FROM dbo_animals**
Problem: I am able to create the query with string manipulation- Unfortunately due to the way the loop through controls is set up- The query is unable to convert the text into a reference. If I hard code it as
tempquery = "SELECT [Form]![Animal Finder]![CB1] FROM dbo_animals" MsgBox(tempquery)
It looks like
Code : SELECT Elephant from dbo_animals
This is how I want. But, since i am looping through CB controls, I have it set up as
Code : tempquery = "SELECT" & " [Form]![Animal Finder]![CB" & i & "] FROM dbo_animals"
and this shows up as
Code : SELECT [Form]![Animal Finder]![CB1] FROM dbo_animals
Thereby giving me an error saying that the reference is not valid and asking me for a parameter value.
This makes sense, since it is unable to evaluate the text as a reference.
How do I correct the text into a reference? Or How do I build a query with adjusting columns based off selections from a combo-box and loop through the comboboxes in the form while auto-updating the query?
I'm using form with subform. Main form header contain a combobox. I need to check the combobox is null or not before update a subform filed. If combobox is null then its back to Main form combobox from subform. The code below that I'm trying to:
Code:
Private Sub AssignTo_BeforeUpdate(Cancel As Integer)
If IsNull(Forms!frmDepartmentReview!cboDepartment) Then
MsgBox "You must select Department first", vbInformation
Forms![frmDepartmentReview]![cboDepartment].SetFocus
End If
End Sub
Then I'm getting 2110 run time error
Access can't move the focus to the control cboDepartment.
I'm trying to disable mouse scroll wheel on the form but no luck here,
View 1 Replies View RelatedI am trying to make a label visible on a form during print if a field has "like a string". We use a form so that it prints 3 forms to one page (They are tags for units for repair). I can get the label to be visible in the form view but when I print, the label is visible on every record where it is only visible on the current record in form view. My goal is to have the label only show on those records where the condition is met.
Here is my code that works in form view only: (It is to designate easier a warranty tag from a new repair tag)
Code:
If Me.Problem_Description Like "Warr*" Then
Me.lbl_w.Visible = True
Else
Me.lbl_w.Visible = False
End If
I have attached an image of a tag sheet Tag_Sheet_W.jpg. As you can see if I got my desired result only the first tag would have a W.
I had an existing database with 2329 records entered into it. All of the fields (220ish) were all in one table. Myself and my co-workers wanted to rebuild the database without losing the data. We wrote queries to transfer the data from the original database to the new database and split the data from the original 1 giant table to 9 smaller tables.
The transfer of data worked so I went to start making forms. When I went to add fields from different tables I had to built a relationship, which I did. All of the data that transferred over from the new database is in the form (now multiple forms linked by button) but I can't add new information. I get an error stating, "You cannot add or change a record because a related record is required in table ..." and the table referenced keeps changing.
I'm trying to search a for string within a subform to find information stored on the mainform to which the particular subform belongs.
The problem is that the subform is generated from a query which uses a number from the main form to generate.
So the subform record is only generated when the correct mainform record associated with it is loaded.
Now to solve my problem I've made a new query that brings up ALL the results that could be generated by the main form and from that I can search to find my search term I'm after and read off the ID number to tie it back to the mainform.
But all of this is done manually, I want a way to do all this using VBA in a way that the user can't edit any records as they are doing it.
Why the ability to view the properties of an object within a form is not available when you double click on it in design view?
I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.
I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.
Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?
I am very new at Microsoft Access. I have two forms, A and B, that are filled out by two different users. Form A gets filled out first than form B gets filled out. Each has a name box as well as a birthdate box and a few other similar text fields. However, each form also has a few distinctive fields. I was wondering how I could input the common information in Form A to Form B so the user of Form B does not have to spend time retyping the name and birthdates again. In other words, I want to synchronize the similar records between the two forms. I would like the values to appear in a table as well. I would greatly appreciate it if someone could help me with the visual basic code. Thank You.
View 1 Replies View Related