Search results

OK did some searching but cannot find anything that's worked so far. I created accdb with backend tables. converted to accde for users. Problem is their forms are really slow to load and take forever. I've narrowed it down to I am running Windows 7 but the end clients are running Windows 10 -...

OK was not sure if this is the best place to post this. I had another thread where I wanted to concatenate records together on a query and form. I used Allen Browne's method mentioned. http://allenbrowne.com/func-concat.html I was able to get this to work well in the queries. The problem I have...

Hello, I have two tables in a one to many relationship. tbl_Test & tbl_tech I may have several Tech's working on one test. I was trying to get a query where I have one record from tbl_Test with the tech ID's show in a single text field. For instance: tbl_test ID tbl_tech 100 W1...

I searched and sure the answer is there. I have a sub-form with multiple checkboxes. Would like to select one and only one. I know I can set the on OnClick event to clear the others. I was curious if there is a better way.

Hello experts. Apologize in advance if this is the wrong place to ask. I am just looking for the advice on reporting protocol. Excel does a great job but normally I have to export, update, email. And A lot I do through code I just know there is so much more. I am able to do this via...

Hello experts. I inherited a problem in a database that tracks safety incidents. User inputs data from a form that is handed in. the issue is with the medium time format. Table consist of, Data Type: date/Time Format: Medium Time Input Mask: 99:00\>LL;0:# this is the Microsoft default...

I just wanted to thank all you for help with this forum. I have really learned a lot from here. All of those retired and current developers who take time out to share their knowledge. I hope one day I can be a helpful as some of those on the board. A big Sincere Thank You! Richard:)

I have a counter that pops up in a user form. the text box is blocked out like waiting for input. I just need it to display the count number itself without the block. I tried switching edit to no and others. I must be missing something.

After searching I finally came up with a script to put table information in the body of an outlook email. I have a few questions to enhance this. 1, The last field aRow(8) needs to have a percent format. 2, I would like at somepoint to be able to add another table to the same email. I suume this...

I looked online and tried several different options. I am looking to have a message pop up when an entry is not completed. The following code seems to work well but I keep getting the message box twice. I understand it seems to be firing twice but not sure what part of the code is causing...

Looking for a query suggestion or SQL where I would pull the first record that contains a certain value and then return all the records after that. I hope this makes sense. for instance ID Pass 1 Y 2 F 3 Y 4 Y 5 Y 6 Y Would return records 2 through 6 or ID...

I was hoping to get some help with this design. It seems so simple but can't get my head wrapped around. design scope: User 1 enters drawing(one) and location's(many) User 2 finds the record and add the additional Pass and various other information. Reports generated, boss is...

hello, I am hoping someone could help with a solution or guidance. I am framing a test report that records testing for each project and the technician who works on it. the have to maintain a qualification or they get pulled from the job for retraining. On the form they enter Project and...

HI, I have been trying to modify the NW database to use as a simple inventory program. Downloaded the 2010 Client version from this site. Essentially I would like to turn off the shipping (or default to single shipper)and redundant payment functions. I am currently running an older version...

Hello, I have been struggling with a design approach for a new database. Basically we manage 6 - 10 projects for a long duration. I may have 100 Technicians qualified to work on various projects. Base on their performance some may become unqualified for a particular project. I am trying to...

I was hoping someone can help a noob. I have a main form and tab form. User enters basic information on the main form which passed to subform. After the rest of the information is entered I have a button which writes to table. the problem is that I need to go to the next record and set...

I've searched and read the older forums. Most what I found pertain to older versions of Access. I am trying to open one access file from another using VBA I currently have the following code: Function OpenWindingDB() Dim appAcc As Access.Application Set appAcc = New Access.Application...

Hello New Member looking to improve my Access Skills especially in VBA