Office - Query records Within a Range of Numbers
Asked By sboyd
22-Jan-10 12:04 PM
I have an SQL table. I need to build an infopath form to query
records in that table within a number range. There will only be one
table to work with. I know that I can query one number but I cannot
figure out how to get the query to get all the records within the
range.
Flight_Id is my primary key in the table. What I want to do is to add
two fields in the query section of the form. I figured I would add the
fields to myFields as From and To. My thought was the user would add
a number in both fields and I want all the Flight_Id records that fall
within that range. We need to update a bunch of records and I do not
want to do them one at a time.
Can anyone help?
Database
(1)
HiI
(1)
MyFields
(1)
Practicle
(1)
Infopath
(1)
Bc76
(1)
Didn
(1)
Mr. Andersen replied to sboyd
I need to do almost the exact same thing in my form. Let me know if you find any resolution from other sources.
sboyd replied to Mr. Andersen
u find any resolution from other sources.
/aspnet/60a4a785-5349-43ba-bc76-d...
Still no solutions. I know someone has done this before. Finding one
record at a time is not practicle when you need to update several.
Any suggestions would be appreciated.
No.7 replied to sboyd
Hi
I have done this with Infopath and an access database located in Sharepoint.
Well, not exactly the same, but with a date range.
I didn???t use the standard query fields, as you mentioned, you can only query
one value at a time. I used some text fields and made a button with code
behind.
You can find the code/setup on my blog, if this is what you are looking for:
http://delepunkt.blogspot.com/2010/02/infopath-date-range-search-with.html
it is in Danish, but if you have any questions, just ask.
unable to rebuild entourage database ( Errorcorruption opening database [-39]) Office Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Email my entourage last 2 days ago but the next day i found the message Entourage database failed to open <br> I tried all what i can do the microsoft 6 Steps data to another mac <br> But Still the same problem is <br> Error Corruption Opening Database [-39""] <br> can any one tell me that what i can do <br> Microsoft saying Error (1) Page (1) Disk (1) Intel Software Entourage (1) Processor (1) Library (1) Microsoft Database (1) Move the 'Microsoft' folder out of your local preferences folder and try again. If do not have enough disk space. Your User?s Library / Preferences / Microsoft Rebuilding a damaged database that exceeded size limit In case the above link does not work: EmailChemy often can export messages from a damaged database. - - Diane Ross, Microsoft Mac MVP Entourage Help Page <http: / / www.entourage.mvps.org / > Entourage Help 5.8 <br> <br> Error Message: An error occurred while attempting to rebuild your <br> database <br> <br> Database Size: 4.26gb <br> <br> Date: 21 / 9 / 2010 <br> <br> I
Database Meltdown after iPhone Sync - cannotopen ANY identity, even new Office Version: 2008 Operating System: Mac for 24 hours, then starting encountering unknown errors - Damon has to quit, need to rebuild database, then cannot open database, then could not get the database utility to open, etc. <br> <br> Tried restoring database from Time Machine, turned off sync, etc. No go. Removed Office completely and reinstalled, for a short while I could reopen the restored database, but quickly could not open the deleted items folder or empty it. Now, daemon has open up the (empty) Main Identity created on reinstallation. <br> <br> How does a corrupted database wreak so much havoc? SHouldn't an old database be uncorrupted? SHouldn't a brand new identity work OK?? <br> <br> Ready to chuck
Entourage and Database Utility Office Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: pop My Entourage program indicated that the database needed to be rebuilt. Database Utility successfully rebuild theEntourage database but every time it completed the exercise, Database Utility would request that the process be repeated. I have now repeated this at least six times! In addition, the option of setting database preferences could not be activated. In order to address this headache, I have also deleted Snow Leopard Processor Intel Email Client (1) Page (1) Backup (1) Date (1) DB (1) Database Utility Version (1) Processor (1) Library (1) On 2010-05-20 05:23:23 -0400 that one of the related preference files is corrupted and triggering this. Try trashing the database preference files and reboot (to make sure everything properly quits and stops using the pref
entourage continually crashes, database size > 10GB Office 10GB" / > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: pop since my database has grown larger than 6GB (now > 10GB), entourage crashes several times a day - seemingly without is frustrating as i wind up wasting huge amounts of time using the glacially sloooooow database utility to verify / compress / rebuild the database over and over again - only to have the same thing happen a day or two but put some order in the system. Each year, in January, I export the Entourage Database to an Archive. Create a New Identity normally labelled the previous year eg: 2009 Log just checked in the Microsoft User Data folder in Documents ? Office 2008 IdentitiesFolder and the Database size for each of the Old Identities ie: 2008 / 2009 is less than 3 GB Mac OS X 10.6 (S = now Leopard) Processor: Intel Email Client: pop since my database has grown = larger than 6GB (now > 10GB), entourage crashes several times a day - seem = ingly frustrating as i wind up wasting huge amounts of time using the gla = cially sloooooow database utility to verify / compress / rebuild the database ov = er and over again - only to have
Import Entourage X database into 2008 Office Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am not having any luck importing my 1.8gb X database into 2008. Part of the problem may be that 2008 does not recognize the X identity. When I check the file type and creator field on the X database they are blank. Is this part of the problem? Does anyone know the right file type and creator codes for the X database? Is it something else? I no longer have X installed on my machine. it is 2008 will have no problems importing Entourage 2004 Identities. Do a Get Info on the database file and select open with Microsoft Entourage. Not sure if this will work properly since you no longer have Office X installed. It?s worth a try. Name: Database Kind: Microsoft Entourage database I do import for clients that have problems. If you can?t find someone with the = X identity. When I check the file type and creator field on the X database = they are blank. Is this part of the problem? Does anyone know the right file