Search results

I have a two column report that I need a group of records to split into two columns. I need the column on the right to start in the column on the left and wrap into the right column. All of my sections are set not to keep together,

I am on Access 2016 64bit. My VBA is not great but I manage. The code I am working with was done by someone else that is no longer available. I am having issues with one of my list boxes. I am not sure but it seems as though it is retaining the previous selection in memory and its...

Forgive me if this has been covered but have been searching and haven't come up with what I'm looking for. I'm trying to have a single or multiple query criteria based on what the user checks on a form. I can't get the True condition to work at all, I get no records. Here is what I'm using...

I have Field1 Field2 Field3 I need to concatenate these three fields into one but for each record the order can be different. What I want to do is have another field in the table to store the concatenation order as the field names not the field values. I also need to display the...

I am working on being able to print pdfs that are stored in a directory from my database. Is there any way to set the page settings in adobe from access. The pages are over sized and need to be scaled down to fit on legal size. I am currently using this code to print the documents but they...

So the company I work for rolled out Windows and Office updates last night Now my tree control menu stopped working. We are on windows 7 64bit and office 2010. The node_click sub no longer opens any of my forms. Any suggestions besides the fact that I was using an ActiveX control to begin with...

My office is migrating its servers from LAN to WAN. My app is the typical FE BE and has been in use since 2005 with no corruption issues at all. The most users that are connected is 10. My question is what issues will I encounter. Right now we have a mix of office XP and 2010. With everything...

After much searching and reviewing I finally found a way to do this with out using dbHiddenObject. Which is much frowned upon. This is a sample I use it to relink certain SQL tables at start up. I had to start doing this due to the variables is the way the workstations are set up here. As part...

I am using a tree control as my switchboard/menu system. Is there a way to set the focus to a specific node when the form loads?

Ok I have an unbound form that is used for searching for records. The results are displayed in an unbound sub form. After the search in done the code then binds the controls and record source for the subform to display the results. All this works great been using it for years. What I want to do...

My problem is i am trying to get an ESRI shape file dbf to import or link in to access. When i try to link it fails because i do not have the ndx file. When I import it says it can't find the object. The purpose is to build upon the dbf because i need more display info.

Ok so I'm trying to get the backend that resides on the network to compact when the last user exits the FE. I have read that network compacts can corrupt the db becuase of the data compacting over the network. I have ran across Rogers compact be code was wondering if there is the same risk with...

I'm trying to create a multipurpose password field to enable some privalaged users to edit some fields in my db. I'm trying to pass the FormName and Control Name via open args. Then if the user inputs the correct password it will unlock that field for editing. Here is the openargs...

My company has asked for an issue tracking database with the requirements that if is someone is edditing records it locks that block down until that user is done. I don't have any idea how to do it. my db is set up this way. tables tblPolls tblIssues Querries qryPolls qryIssues...

How can I get a form to have multiple colums.

How Can I remove line breaks in a string.

Ineed a Db converted to 97 can some one do it for me. I only have 97 on my machine at home

Ok I've been reading on backing up Dbs here. I have a db FE and BE I need to do back ups currently I backing up my FE with the autocompact db found in the sample forum but can't use it to back up my BE when it's open. bascialy I'm trying to backup the BE daily but how do I do it if some is in it?

How to prgramaticly remove the record source for a form. and the control source for the controls.

Ok I want to do auto backup using the auto compact db, I think I got from here., anyways I want to copy it but the auto compact cant because of the DB password is there a way around this like have the password in the path of the db?