Search results for query: *

Here's my tiny example... I have a report with a column definition that includes a column for calculating the % of Gross Sales as well as a column for calculating the % of Net Sales. In the Row Definition, I set the CBR to row 280 (gross sales). A little further down in the rows I set the CBR...

I have a form (fUploadImages_Batch). The form contains 3 objects: txtPhotoBy txtPhotoDate btnBatchLoad The record source of the form is a table called "tImages" and contains the following fields: ItemId = AutoNumber PhotoBy = Text(255) PhotoDate = Date/Time ImgFileName = Text(255) ImgDetail =...

Hi - I'm using this program DBPix and it's just great for what I need it to do. I can upload a batch of photos or a single photo, depending on my needs. My table for storing the images is pretty simple: ItemID (autonumber) ImgDetail (OLE Object) DetailWidth (Number) DetailHeight (Number)...

Hi, I know there are a lot of posts out there on importing an excel spreadsheet into access, but I can't seem to paste them all together to find something that works. Here's what I have: table name = tImageLog primary key of table "tImageLog" = ItemID (data type = number) form name = fAllInOne...

While attempting to mirror two sql servers without a witness server, the following error kept coming through right at the end: The server network address "TCP://MOSSSQL-B.mka.compute-1.internal:5022" can not be reached or does not exist. Check the network address name and that the ports for the...

We have several thousand sites with a hierarchy such as: http://acmelive.acme.com/projects/atl/2009 Each site contains the same document and list libraries. The 2 that we are most interested in are: > Documentation (document library) - Contains several file folders for organizational...

Hello - we have been killing ourselves! By any chance, is there a way to run a list of sites that have no documentation stored in them? Any help would be GREATLY appreciated. Thank you. MOSS2007

Hello... We have a few servers running windows server 2003 standard. Is it possible through either tools that the server has itself or a third party software, to run a daily report that will list the "files" (not directories) that were either read or written to each day. Any help to point me...

hi there... i'd greatly appreciate any help on this little annoyance of mine. i have the following fields: Address1 Address2 City State Zip they may or may not have values in them, depending on the situation. however, i still would like to concatenate them into a "nice" flowing string with...

hi there - i'm new to creating data access pages, so please forgive this simple question. to use a very simple example, i have a "clients" table and a "clientnumbers" table. the clientnumbers table is the "many" side of the one-to-many relationship between the two tables. i'm creating an...

Hi there, i wonder if anyone can help shed some light on where i might be going wrong with this formula that i'm using in one of my reports... the field names are listed below: txtAFee1Total CmpdF2P CmpdF2LS Heres where i'm at now: =IIf(nz([CmpdF2LS],0)=0 and...

hi! would love some help on (what i'm sure to most of you is simple) this list box problem... i have a form with the following fields (form name is fCorrespondence and the table name is tCorrespondence): CorresID EnteredOn EnteredBy CorresDate TransmittedVia ReferenceNo Task From To...

hi - love this website and use it often, but first time posting a question i have to tables (A & B) that have the exact same 6 fields: ItemNo, Description, Unit, UnitCost, Quantity & Total i would like to compare the two tables (based on ItemNo) and return the results from both tables. heres...