Search results

still pending project. hello all. revisiting this topic. Any ideas?

I have a report that pulls data from a query. there are 3 unbound fields with: [Enter Name] [Enter Home Phone] [Enter Cell Phone] as the control sources These 3 fields change all the time so there is no need to track this data. So my user opens the report, is prompted for these 3 items. Once...

Right... I see where you guys are heading with that. Thanks and it looks like it will work great. Thanks.

So I need to keep column [EmpSS] in my report, but name it "EmpSS_txt" then create a new unbound field and add my formula: ="XXX-XX-" & Right([EmpSS_txt],4) And the name of the new field does not matter. Then 'hide' the original that I do not want them to see???

i have a field [EmpSS] that i want to mask in the report not in the query. I make an unbound field in the report then asign this code to the control source. It brings up an error. ="XXX-XX-" & Right([EmpSS],4) Can I asign a mask at the report level? I know how to do it at the query level...

tbl_RECORDS qry_ADD frm_ADD I have a basic form that shows one current record from my qry_ADD. [TotalHours] is a column that tracks total hours worked on a project. [Text22] is an unbound box that my tech will enter current number of hours worked. [Text55] has a formula in the control source...

I found a way if I have both tables in a query on the backend. Then add both PK fields to the form. It will work then, but it looks silly making someone add the [CompanyID] to the form 2 times.

I have 2 tables with a one-to-one relationship. I want to make a form for entering a new client. "Add New Client" Is there a way to make a form with the various blank fields then when I click "add" it Adds the record to both talbes? tbl_Account tbl_History CompanyID is the PK for each talbe.

I have not ever done this either. Someone else needed to know. I can make an update query to do the same thing. Thanks guys.

I have a basic form with one unbound box. I want to type a number into the unbound box and have it automatically add the number to a field in the table. Thanks.

Is it possible to add an Iif Statement to a default value? IIf([hours],"YES","NO") This does not work?

I do not understand if this is sarcasim... maybe I was not clear. I have a field called SampleID. A 7 digit number will be in the column most of the time. If the number starts with a 1,2,3,4 I want a column [SampleID2] to say "DOT" and if the 7 digit number statrs with 5,6,7,8 it will display...

SampleID2: IIf(Left([SampleID],1)<=4,"DOT","Non-DOT") here is my query which works great almost. If the field is blank then it will get a "DOT" status. Can I change something here to not add anything for a null value? thanks

Rural that worked great without adding a macro. nice thanks. It closes after the compact which is great, but why does it do that?

Thanks here is my batch file: "C:\Program Files\Microsoft Office\OFFICE\MSACCESS.EXE" "F:\MAIN.mdb" /x QUIT Then I set the DB options to Compact on Close. I could not find the actual settings in the MACRO to compact & repair. So I set the mac to quit the db. It does the compact on close so it...

Doc that sounds great. Do you have any examples that i use as a guide? I will not know how to do this unless I see a sample. 1.) Create a batch file that opens the DB. 2.) Create a macro in the DB that does a compact & repair, then close DB How does a DB know if it was opened by a batch...

nope does not work. sorry. This will kill the app, but it does not compact on close. Technically it is Access is being killed not closed. I will keep trying. This will work if I can come up with a command for close istead of kill in batch file.

Nevermind all... I found a solid work around. If you need to manually run a compact and repair daily here are the steps: 1.) set up a scheduled task (start - control panels - scheduled tasks) to open the DB. 2.) Have the option set to "compact on close" 3.) Write a batch file (start -...

also can you write a batch file that will close all open programs?

I have a large DB that I want to compact & repair daily. I have the option set to "compact on close" is there a way to write a batch file that will open the program, then close it again so it will do a compact? if not a batch file then any type of program that might be able to handle this?