Search results

@David_R I have 42 posts now 43...I don't know why you are not able to see the screenshots...but thank you for the questions @missinglinq Sorry zipping up is unfeasible @spikepl Thanks for the idea...I did check that. I will figure it out.

Anyone have any ideas? No matter how insignificant you think it is. I have a feeling it is something simple I am overlooking. The listbox that is highlighted under "Pumps" is the key.

Okay I am having one of those moments I guess. I have a Subform that is inside a Subform that its only purpose is to display some calculations but for some reason it is blank. Here is a screenshot of what I am dealing with: See that area under "Pump Calc" that is blank...it should have data...

No problem glad I could help!

What I would do is lock devbox2 and entitybox2 either in the form_load or using the properties sheet. Then in the areabox2_AfterUpdate event I would place this code: Private Sub areabox2_AfterUpdate() If IsNull(Me!areabox2) Then msgbox "Areabox cannot be blank" Me.areabox2.SetFocus...

To update a combo box's query you would use the requery function Private Sub cbo2_afterupdate() Me.FieldOfATable = Me.Cbo1 & "; " & Me.Cbo2 Me.Cbo1.Requery Me.Cbo2.Requery End Sub I hope this helps.

I am working under the assumption that the two combo boxes are unbound and that your form has the data field listed in its Record Source... this is how I would code it. In the afterupdate of the second combo box Private Sub cbo2_afterupdate() Me.FieldOfATable = Me.Cbo1 & "; " &...

Well low and behold there is a problem and it isn't with Access...okay well not only Access. It has to do with Set custom text size (DPI) in Windows 7. I usually adjust mine to 150% to make things easier to read on my screen. Changed it back to 100% and now Access Command Buttons are being...

Oh come on...command buttons with themes are nothing new. They worked fine in Access 2010. Why don't they work fine in Access 2013? That is what I am asking. Surely this has happened to other people.

Yes remotesk that is a work around...but I like the themes and it just bugs me when something doesn't work like it should.

Yes they are set the same. Not too sure what is going on :banghead: Sorry remotesk I know what you mean...but no solution.

First make a copy of your DB and save it somewhere safe. Always a good practice just in case something goes terribly wrong. Then split your database. You will have your frontend and backend in two different DBs. Open your frontend and delete the linked tables that you want to hold just...

Access 2013 People, Have any of you experience a situation where the command buttons are not displaying properly? Here is a picture of a DB from Access 2010: Notice the words and images are nice and centered in the buttons. The buttons are all the same size. Now look at the same DB in...

Cool...there is always more than one way to get the job accomplished.

I am sorry I need more information. What is not working? Does it error? Did you copy and paste the code? If so try typing it out and see if Access will ask to install the reference for it. Let me know and I will be happy to assist you. Thanks

One other thing and I hope this makes sense...and maybe another coder can jump and explain it better then I can. When you type the code into another database and type the following Dim fDia as office.FileDialog You will notice that "Office" is not in the dropdown list after typing "as"...

Okay I went out and researched the Application.FileDialog function and came up with some new simplified code. Try this DB out and see if it works.

If you could would you please upload the DB that you changed. I would like to see what is different. thanks,

Wow I have no idea what that is all about. It works perfectly on my computer Windows 7 64bit. I have even went so far as to compile the code for the db and it doesn't error either. Sorry I couldn't help you.

I built the db with a 64bit system so I don't understand why it wouldn't work with that same kind of system?? What kind of an error are you receiving??