Search results

Thanks so much Bob!! Now I can get back to my regular project.

Okay Bob now it looks like I can add new records. However, with the first statement SELECT Clients.*, [Attachment].FileName FROM Clients; I have 69 records and now I only have 53.

Do I take out just the word Attachments or the whole select statement?

It's a table.

Okay. I can't modify the records. Allow Additions is set to "YES" Here is the code on the record source: SELECT Clients.*, [Attachment].FileName FROM Clients;

Yes, it was set to "No" already only I couldn't see the full properties until I took the code out. Now it opens without error and I do see records in the form but nowhere to put in new.

Now when I open it I can go into properties. Before it wouldn't come up in this view it would just come up with blank properties. The data entry is set to "No".

Shouldn't it open to a blank sheet where I can put in new data? I don't see anywhere to add new.

Okay. There is nothing in the properties but I did delete the entire code and it opens without error.

Hey Bob baby steps. How do I check the data entry property and will I need all of the code you sent or just go back to the old after I delete the "yes" Thanks!!

Thanks Bob! However, I still get the same error and if I run debug it still stops on DoCmd.GoToRecord , , acNewRec

Can you tell me how to fix it. It's been a long time since I've worked with MS Access. When I hit debug on the error it just shows me Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub

I didn't create this .accdb. I've been asked to help fix the error but when I open the .accdb it gives me error 2105 upon opening it. I've tried decompile/compile (grayed out), compact and repair (which does nothing). Any/all help will be appreciated.

missinglinq thank you so much!! I bit off more than I could chew this time. It seems to have worked but I won't know for sure until they test it. Is there some where we can talk outside of this forum or a chat on the forum? I don't know if I'm allowed to give my email address so I'll just...

Okay. I have two projects I'm working on and need about the same for each. This one has no info in it yet so I can upload. The two requests are: In the frmProductMasterList there are fields called “Size(oz.)” and “Size(lbs.)”. Those are the fields that will hold entries regarding the size...

Okay... Gina I would use conditional formatting except I know nothing about it. I've been out of the field for 6 years and ended up taking on two projects for non profits now I'm in over my head. I suppose I can take the other raw project and post as I just want this over with. As soon as I...

Okay. Trying again. I am posting my code and marked where it stops. Looks like I'm getting somewhat closer?? Thanks for hanging in here with me. Private Sub Mass_AfterUpdate() If Nz(Me.Mass, "") = "" Then Me.Volume.Enabled = True Me.Mass.Enabled = True If Nz(Me.Volume, "") = ""...

I would love to post it but I can't. There is a lot of sensative information that would not be allowed to share. I tried your code in both the forms On Current and On Lost Focus. I've tried it a million times even trying one event at a time. I also tried the code from the forum post of "make...

Shoot. I see what your saying. They were added under the wrong fields. Still nothing happening when adding them under the right fields. I've been out of this for quite a few years. It's really hard to jump back in.:confused:

This didn't work for me?? Nothing changed for me. When I did it following: Private Sub Form_Current() If Me.Mass = 0 And Me.Volume = 0 Then Me.Volume.Enabled = True Me.Mass.Enabled = True Else If Me.Mass <> 0 And Me.Volume = 0 Then Me.Volume.Enabled = False...