Search results

I have a text field that has a value in it something like this; PACTS11233 or FED11233. I need to display the letters in one textbox, and the numbers in another textbox, both in a form and report. It is always 3-6 letters and 5 numbers. I can use Right() function for the numbers. But since...

I have some reports that have 'Export" on the shortcut (rt-clk) menu. On other reports the option isn't on the shortcut menu. This is with all the reports in print-preview. What might cause this?

I got an error message that approximately said that one of my backend data files was in an "Inconsistent state..." and was going to repair it. After it did the repair the file had shrunk in size by 75% (as reported by windows explorer). Needless to say this really concerned me. I had made...

I have a report that runs code in Report_load, and based on the value of a field it sets some objects Visible=False and others Visible=True etc.. Now I'm trying to move away from acViewPreview and print direct to the printer with acViewNormal but the Report_Load event doesn't run. Is there a...

Not sure if this makes sense, (I'd rather not create a comments table) A user enters text into a memo field for an existing client, then it's closed, the same record reopened and more entered into the memo. The problem is when it's reopened the existing text is hi-lighted, and it's really easy...

Can you send a report directly to the printer? We have Clients with multiple Contact Notes, by multiple Clinicians, each of these are separate tables. Every month we print two reports for each client that had at least one contact in that date-range. Usually 200 clients, takes a lot of time. My...

I have a form & related report that works best for the end-user, to open first in ReportView so they can still sort it, and then still go to PrintPreview before printing. On the report I have a print button with the following code, "Docmd.RunCommand acCmdPrintPreview". it opens PrintPreview...

Hi, I have to create a control on a form that will be able to change to one of ten colors, some of them are subtle shades. I will be doing this from vba on the control. I know how to do all of this except defining the colors. I keep seeing the 3 part RGB(xx, xx, xx) etc. but I can't find the...

I have three Access back-ends in a db I've developed in 3 phases. Two of them fall along functional lines. One group of users works mostly out of Phase1, though not exclusively, and another group works mostly out phase2. Eight people are now in the db a majority of the day. One of my backburner...

Every time I mentioned multi-value fields I get the same input, don't use them. So I am trying to replace this field with a junction table. This will have multiple records for each record in the original subform. The only problem is that the original subform is set to continuous view and now I...

I am starting on a Join table in my database. I know I will have; a FK from Table1, a FK from Table2, a PK in the Join Table, and I need a date field at least in the Join Table. I would like to place 3-5 fields additionally in the Join Table. Should I add these fields to the Join Table or not...

I have a report with 2 subforms. The Main report is Client info. Sub1 has ContactNotes for each client. It is in the detail section of Main, is in continuous mode, and is related to Main thru key ClientID. This prints good. Sub2 is a signature block for the report. It is unrelated. It looks at...

I have been developing a db in AC2010 for a non-profit org. Now some other similar organizations are showing interest in it. So... What about revision control, bug tracking, etc. Are there any free or cheap app's out there for helping in this area? What else do I need to be planning for? (other...

I have a split database where the front-end links to tables in two different back-end files. (access 2010) Then, there is a lookup field in back-end#1 that looks-up a field in back-end#2. It's all been working. But... The customer wants to be able to store multiple values in that lookup. I went...

The non-profit I am creating an Access db for just has a router network, windows 7 on all users, with an Ext.HD attached to one PC. The back-end of the db resides on this path - \\Clinician\h\Database\Alano_be.accdb. I do most of my work on the front-end from home. Is there a way for me to...

I have created a db for a nonprofit counseling org. I had created the first half, mostly administrative tasks, called Phase1, and put the BE on a network drive and the FE on multiple users. Now in developing the clinical portion, Phase2, I linked to four of the tables in Phase1 BE file. Now I...

I am running an Access 2010 db, split and running on a small office network. I just found that one of my tables has this problem if I open it from the front-end. There are 26 records that have #ERROR in each field of the record. There are 155 records w/o any problems. If I open the back-end and...

I have the back-end of an Access 2010 database running on a network drive. The database thinks that there is still someone logged into it. I have made sure that there is no one actually logged into it. In file explorer there is the second file (record-locking) still present and I can't delete...

I am running an Access 2010 db, split and running on a small office network. I just found that one of my tables has this problem if I open it from the front-end. There are 26 records that have #ERROR in each field of the record. There are 155 records w/o any problems. If I open the back-end and...

I am trying to develope a form (called ContactNote), to enter a note into. Basically it is for a note that a Dr/Therapist needs to enter each time they have contact with a patient/client. I want it to be a pop-up that can be accessed from any screen. The ContactNote table has the field...