Search results for query: *

Hi all, I have a statement (that dhookom helped me with) in a query that i use in access that i need to use in SQL the statement is: Mid([Unnamed Field], Instr([Unnamed Field],"A-")+2) i get an error that says Instr() is not a defined function, can someone help me rewrite this so that i can...

Hi all, so i am building a query to show all of the leases in all of the tracts that are set up in my db, being that there are many leases in each tract. however the desired output would be each lease record listed with the tract name repeating however many times it has to. that part is easy...

Hi all, I have an access front end link to SQL tables. on a particular form, when i update information on a subform it takes it fine, but after when i try to navigate to the next record or select another record from a combo box, i get an ODBC call failed message and the data in the subform...

Hi everybody! the title says it all, i have a text field that contains a name then an Abstract number and i would like to get the Abstrat number (or the value in the string after "A-") so for example a record would show: Lost500 Survey, A-74 I would like to get the A-74 out of there!! there...

Hi all, I am running a query where i would like to find a minimum date in a group of records and also include some other fields with it. the problem is when i add more fields to my query they are defaulted to group by so, where i want to see the Unit name for the record with the min date, i get...

Hi all, I am runnig a query (including a few tables) and it runs fine except that initially there are 500+ records in the result until I highlight a column and sort alphabetically and suddenly there are only 475 records... i don't know what is happening and it scares me. this is going on in...

Hi everybody, I have a SQL db that i recently upsized from Access. my table relationship worked fine in Access but i'm having trouble in SQL. my table structure includs one "Main" table with a primary key field that was related to three "Sub" tables all connected on the primary key and all...

Hi all, I am trying to upsize a very simple access 2007 db to a SQL 2005 db. when i run the upsize wizard and select create new database it doesn't make the server connection (the SQL db will be on a different server than the access db) all of my tables have ID fields (which are my primary...

Hi all, I am trying to upsize a very simple access 2007 db to a SQL 2005 db. when i run the upsize wizard and select create new database it doesn't make the server connection (the SQL db will be on a different server than the access db) all of my tables have ID fields (which are my primary...

Hello, I am trying to find a way to control the external lights on a laptop which is running constantly. I believe that its a API function. There is a back-lit "HP" light on the back of the laptop that shines all too bright and gets hot. I would like to be able to turn it off and it...

I am making a view to return the Sum of acreage records grouped by location. the view runs fine but i would like to use something like an IIf function to return the value "1" if the summation of acreage records is greater than 1. My code is as follows, sorry i forgot how to make code look like...

ok this SHOULD be easy... I have a view and i would like to add a WHERE statement to exclude records that have been marked 'Expired' This is a totals view and i think that is why i'm having trouble and maybe i should use two views to get the 'Expired' records out of the dataset first, and then...

Hi all, I'll start with i have no idea what i'm doing. I have a table that records the expiration date for each record. what i am looking for is a table or view or maybe something else that will calculate the days until the expiration date ( Date()-[ExpirationDate]) I can do this in access...

Hi everybody, I'm trying to write a query to only return the 'core' or 'original' records for instance: i have a field called FileNumber and it contains values like FileNumber: TX-100 TX-100-A TX-100-B TX-500 TX-500-A the query would only return TX-100 and TX-500 so that i only...

Hi everybody, so i have a query that gets it's criterea from the form that the report button is on. in the query criterea i have [Forms]![frmLeaseInfoReadOnly]![LeaseNumber] this has always worked just fine for me but today when i walked in and ran the report it prompted me for the parameter...

Howdy, I have a multiple access databases that all point to a sql DB on a seperate server. right now everyone has their own datasource via ODBC. is it ok to instead point all of the access DB's to a single ODBC datasource on the network? in short, can two computers utilize the same file...

Hey everyone! I have a report with two fields side by side I want the values to apear side by side regardless of how big/small they are. I've selected Yes for can grow/shrink on both fields but they stay where they are and if the value is too big it still cuts it off. How do I make the right...

hey peeps, I have multiple access databases linked to a sql database and when i make changes to the forms in my copy i would like it to update the other copies. in 2003 i used a replica set but i don't think 2007 has the function and it was very buggy to begin with.. or maybe my code was :)...

Hey everybody, My question is that when i make changes/addtions/deletions to sql tables how can i update multiple access db's automatically? I have a sql database with many access frontends. the access db's have odbc linked tables to the sql db. it gets pretty bad having to go to everyone's...

Hi all, I am trying to make a query where it prompts for the first couple of letters of a value and then returns values that match. I'm trying things like: Like [enter the first three letters of the unit]* I know thats way wrong, and if i didn't access let me know very quickly, also i'm...