Search results

I just tested @LarryE's method and RunCommand acCmdSortAscending sorts a form by the first visible column of the combo or listbox. Therefore, @Danick, there is no need not to use the AutoNumber primary key and Long Integer foreign key. If you want to sort by multiple fields, do them in reverse...

hi @Danick according to my notes, you can sort a form by the column of a combo that's not in the RecordSource using this for Order By: [Lookup_ControlName].[ColumnName] isn't Access totally amazing? EDIT 13 July corrected the reference WHERE ControlName is the Name property of the control...

hi @dobseh > 150 fields wow! That definitely indicates a structure that could benefit by being normalized! I suspect many of the tables were created by importing. The import wizard is OLD! And doesn't set (or not set) properties that are good to use now. Best to examine the table design and...

adding on ... while you can use duct tape and bailing wire to get what you want, do you always want to jump through hoops? question: do you have control over the data structure?

hi @dobseh > I inherited this database from someone while that is the case, doesn't mean you need to keep the same bad structure. Normalizing will reduce development time down the road and make everything in the future go a lot smoother. To convert data: 1. create cross-reference table 2...

Hi Nate @naterook Welcome to AWF. I'm self-taught too, having learned Access many years ago when it still came with books (which I read cover-to-cover) I've learned much more though, from participating in forums! ... because someone else had a better solution than the one I proposed. We get...

hi @gemma-the-husky for manipulating image files with Access, I like Irfanview since it has switches you can end to the end of the command line to change things. Here's an example using VBA to use Irfanview to resize http://msaccessgurus.com/VBA/Code/Irfanview_ResizeImage.htm ... and in...

thanks, Colin @isladogs -- great examples too ... very creative! Good teaching and fantastic food for thought

hi @access2010 (what is your name?) I just happened to see your post -- next time you want me too look at something, tag me not sure what you want us to look at. I downloaded your db and looked at code behind the find combo... first, before moving to another record, save the current record if...

hi @ekje most important to remember is that, because data takes time to bring down, only bring down what you need. On forms, RecordSource should be limited to show record you want to edit. For populating RowSources, use pass-through queries It took about a week to build an Access app -- then...

delete rst_PDF! -- you only need Me.txtLocation if that contains the full path and filename

you're welcome. Does that mean you changed it and now it works? or is the issue that Exit Sub is there? If so, put a Stop statement in, temporarily, before the Exit Sub to verify it actually isn't working. My guess is that code isn't going to that statement. Is it inside an IF block?

@A380b747 as long as you're browsing for the file anyway, why not just copy it into a Files folder under the back-end database and store the path\filename? You can also include the initials of the person who added the file to make it easier to see all of their files ~

hi @A380b747 > other users need to have access is your database split into Front-End and Back-End? If shared filed are placed in a folder under the back-end location, maybe called 'Files', then a relative path can be stored that is different for each user but still points to the same place.

hi @A380b747 echoing @theDBguy's comment ... best not to store external files IN the database. Better to store path\filename and render with Image control if pictures or maybe Web Browser control for other types of files. I like to put all files referenced by the database in a folder under...

hi @sekoma Reports have a Running Sum property so it's easy there ... Choices are No Over Group Over All To show a running sum on a form, you need to do a calculation. Easiest would be to use DSum. The problem though, is what if the form is sorted differently? Or there is criteria to...

you're welcome. @Manos39 -- forgive me for looking too fast to notice all your specifics... hopefully the example back has given you understanding -- for if you are responsible for the database, you must comprehend what is done each step of the way. My goal is to teach, not do it for you ~

Now there is an attachment -- thanks for noticing there wasn't Colin @isladogs ... @petertheme edited his post to have the attachment

you're welcome, @Manos39 It would help if you explain your logic better ... what you're trying to do in real world terms one of your screenshots shows a drop-down list for a combo RowSource -- you didn't mention that and I didn't look at that when making the sample db which mainly illustrates...

you're welcome, @Manos39 I did the example quickly since I'm working on something else today -- so maybe the logic you want isn't quite right. There shouldn't be a different whether you use Datasheet or Continuous forms --- but no need for criteria in the RecordSource when you use...