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 =...

I was able to hear back from DBPix and the problem was resolved by taking the following action to the code I pasted above: Replace the following line: DBPixMain.ImageLoadFile (strFullPath) With this: If DBPixMain.ImageLoadFile (strFullPath) Then [PathField] = strFile End If...

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...

1.) I user I was referring to was a domain user with admin rights on the local server, ie NOT the domain admin as I originally posted. 2.) After successfully running the SQL service under this user account on a new instance AND using a log backup as well as a full backup, everything worked...

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...

sure, our structure is setup like such: http://xxxxx.companyname.com/Projects/SDG/2009/2009_0826/Documentation/Forms/AllItems.aspx We have multiple file folders within the "Documentation" document library. We want to search all the the subsites of "Projects" (and their document libraries) to...

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

ps... it would be great if some of the fields on the report would be "file path", "file size", and "date" either read or written to. I'm hoping for an export of raw data into either a .txt or .csv file format. thanks again for any insight.

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...

thanks so much euper & sahmiele! both methods work great. i appreciate your quick response - they've made my life much easier! enjoy

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...

hey ken, yes, it is bound to tCorrespondence.

Mostly for just entering data, but it would be nice to use if we ever had to go back and look something up. thanks ken

from tProject (which has the following fields): ProjectID ProjectName thanks Ken!

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...