Search results

I use the below code to add a record to my database. It works great except I just can't figure out how to move to the newest record added to the form/database. If you don't mind taking a look at it and see if you can find what I am missing? Thanks. If Not Form.NewRecord Then If (Not...

I am starting to get back into access and I am finding out that I am very rusty at it. I am having a hard time figuring out how to open a form from a button on a specific record. What I have is a table that is built like this: Shop Table ShopID Shop What I want to do is have a form that...

Someone here helped me with this code before but I am still having a small problem with it. If I only have one record for the PartName or nothing at all it errors out with something about EOF or BOF. I am not sure what to change to keep it from doing this. On Error GoTo Err_Handler Dim s As...

I want to say thanks for all the help I have recieved from here. This is the best site I have seen of this kind! My statement needs to work basically like this: If order is not null then if status is = "FMC" MsgBox "You still have an order!" end if else msgbox "FMC is now selected" end...

I have a label I want to change on a subform but ant it to change when data on my main form changes. frmMain frmMainSub and the label name would be label1 which is on frmMainSub. How do a I reference label1? Thanks

found my problem! I have a form that has a subform on it that contains my data I am working with. For the most part the data is based on one table (tblMissile). I am creating another table that uses the ID from tblMissile in tblMPartOnOrderSort. I added both tables to my relationships and set...

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 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...

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

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

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...

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 have two tables Student Info Table and Block Comments Table. The tables are connected using a autonumber key from Student Info Table:StudenID using the relationship table I want the be able to open up a form based on the Block Comments Table by the StudentID so that I can have just the Block...

Ok well its not actually opening a form but what data shows up when I open it. Here is what I have: Class Table Student Table Comments Table Class table is the main table of the program and Student table is linked to it through the table. I created a form on the Class Table then created a...