Search results

I am having difficulty with a delete query. It works fine if I run it from within the query itself but if I add to a button on my form it will not delete my record. I have linked it correctly to my database. Any ideas? Thanks

I don't know if this will help you but I have a database I made that does a what you are asking for. Open up the Class Roster form. You will see a check box the says AFI. If you click that and then close the form it moves the record to another table. Hope this helps ya? I had to strip it down a...

Yes I do. I created a delete query that works fine when i run it stand alone but if I attach it to a button on the form it doesn't delete my file from the database. Really strange how it is acting.

I am still having difficulty getting my delete to work. I fixed the link problem but now when I click delete it removes it from my form but not from my database. Not sure what is causing this other than maybe my relationships. I checked them and they all seem to be set correctly for deleting...

I figured it out. I didn't referrence the form that the tab control was on correctly...

I am using the following code to delete some info from one of my forms and it works fine when the form is alone. If IsNull([Forms]![qryMType]![qryMissileInfo Subform]![ComboPartName]) Or [ComboPartName] = "" Then DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem...

Thank you very much.. the reference to DAO 3.6 library was my problem... I must say this forum has been the biggest help...

All the information above this post is if I import all my database info into the calender program and the below information is if I import the information from the calender database I get an error from this line " SetProperty "MultiSelect", dbLong, m_MulitSelect " saying that dbLong is a...

Not sure if this is correct then. I am using this on one button Dim s As String Dim db As New ADODB.Connection Dim rs As New ADODB.Recordset Dim rsFind As New ADODB.Recordset Dim Icount As Double Dim Rcount As Double Dim MissileID As Double Dim NewPartName As String 'Open db connection Set db...

Can these be used in the same database on different functions or do I have to use the same type of connection to the database throughout? Thanks

The problem with it is I have several textbox's and when I run the requery it goes back to the first textbox. I have to tab back through all my textbox's. I figured out a way of making it work tho. I just made a button to run the requery with. I think that will work out better.

I have a subform that is continous. Several of my text boxes on the subform do sorting. On the afterupdate function I have docmd.requery. This works fine except it changes focus on the subform to the first record. Is there anyway of stopping this? Thanks

Found the answer! Just wanted to post that I found the answer to my problem. It sure was a lot easier than I thought it would be. Hopefully it isn't a problem posting a link to the website I found it at. http://www.cse.dmu.ac.uk/~mcspence/New%20features.htm#Conditional%20formatting

Looking at conditional formatting now.... If I am thinking correctly I am going to have to reference the engineID and check the date that way.

I guess I didn't explain everything out. I am using a contionous form that has the date for each eng is due. I need to be able to see which engine is due within 6 months and if it is have the background or font turn red. Thanks for the help it has gotten me a little ways but trying to make each...

Not sure if this is the correct forum sorry if I am wrong. I have a date field in access that I want it to do two things. I would like it to display the Month and year ie; Feb, 05. I know access is tricky with this but nothing I do will work. The second thing I would like it to do is if the...

That was exactly what I was looking for.... Thanks again for your help! I even tried all the don't do this examples on that page...

Hey Jack hows you doing? I was able to figure out how to open up the Comments Form off of the Students subform. Only problem is I can't get the StudentID to auto update on the comment form correctly. Thanks for the links I am going to read it now. Jack

I am trying to run a form with a subform. Then I want to open another form off of the subform using a specific ID and can't get it to work. I can open the subform as a stand alone form and click the open button for the new form using this code and it works just fine and updates the field for...

I tried what you said and also this and it is still a no go for me.... rivate Sub OpenBlockCommentForm_Click() On Error GoTo Err_OpenBlockCommentForm_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Block Comment Form" stLinkCriteria =...