Search results

Need suggestions on which SQL class to take. My works willing to pay, one of these classes is $3k which is kind of putting them off but they are still willing to go it if I really want it. What I do: LOTS of reporting. I hit all kinds of databases with all sorts of queries. We've got Oracle...

I have a list of stuff that I have to querry on a Linux based server. Each file is named by date, and the stuff I want could be on the date listed in my report or on either the prior or 2 days after due to GMT and other wishy washy stuff. So what I want is to have a list of dates + 1day prior...

I have a bunch of memo fields and none have the same info in them. But in all theres a point in which the the memo states something like: Incident date: 05/14/2010 9:32AM GMT or Last seen: 2010-05-14 17:45 Z etc. So the date format could be any format really. And where it is in the text is...

I need some help parsing a paragraph. If someone could give me some quick example code I'd appreciate it. This is an example of what will be on a memo field called "Txt_26" on my form. And I just want each data set in a sepperate part of an array so I can pick out the IP, phone, etc...

I looked arround and found stuff that gives offsets or GMT... What I really need is something that will spit out CST... like CST() I can not believe Access doesn't have this already built in. lol

Ok, I'm having a locked record problem. It occures to me, the simplist solution to my problem would be to excluded locked records from my dataset. Is there a way to exclude locked records in a query? Me.Locked = No or something?

I have an Access database that's split into front and backends. Every once in a while the back end gets messed up and only a compact and repair will fix it. When this happens, I notice that the lock file is still in the folder. I think what is happening is someone is shutting down their...

So I have a forum based on a Query. The Query is read only, nothing I can do about that, it is very complex and the order in which the records are displayed is important, so there's nothing I can do. When the Query reaches 0 records the form blanks out... loses all it's controls. Even subforms...

So I have buttons that "Go to the next record" and that "Complete the record" (put a time stamp in the record that it's been worked) The problem is that the form is based on a querry, and once all records have timestamps there are no records for the querry. So when you click the "Go to next...

So I have one field that is "Next callback in" which will be set to how often we need to make a call. 1, 2, 3 hours... etc... I have a table where every time someone makes a call, they make a timestamp. Now, I have a query that combines this info. I want the record to show up, when the last...

the long and short of it: I have 2 tables: tbl_Tickets tbl_Updates They are linked via a common field, ticket number in the tbl_Updates I have Ticekt number USRID Working TimeStamp I want that when a user opens a ticket in tbl_Tickets (via a button) it creates a new record in tbl_Updates...

So I'm building a database that gives users tickets to work. When they open a record, I want to stamp it with a "So and so is working this" and not let anyone else pull that record for 30min If the user clicks complete, it puts a second time stamp that closes it. I can do all this so far. I...

I've got code to create an email in VB. It works flawlessly... My one problem is that I don't want to send the email from my default account... I want to send it from my departments account. I have permissions to do so... but I can not find the control to put the address in my code. There is...

Bellow you'll find the origional article I was working with. I got it to work just as it says. I know its 2 years old, but its all I could find. My problem is I want to do the same thing, but work for the NOAA weather alerts. i.e. http://www.nws.noaa.gov/alerts-beta/ I want to be able to pull...

So I have 2 tables: Names: Jim Tom Sam Clothes: Shirt Shoes Pants Hat So... I want to make a table from these 2 tables: Jim's Shirt: Jim's Shoes: Jim's Pants: Jim's Hat: Tom's Shirt: Tom's Shoes: Tom's Pants: Tom's Hat: Sam's Shirt: Sam's Shoes: Sam's Pants: Sam's Hat: How do I do...

Ok, so in an attempt to make my DB the right way... I've decided to make a link table. Here's what I'm tryin to do. I've made a table for each data set and given each record an id. I have a list of sites: Chicago 1 Newyork 2 SanFransico 3 LA 4 I have a list of products: Cars 1 Phones 2...

So I have a DB that I made to track problems on a network. I don't want to get into what it does because it will get overly complicated so I'm going to just use an analogy. Lets pretend that I own several hundred fruit stands, I want to track if I'm getting bad fruit from my vendors. There...

I would like to erase my table prior to updating it. I have created a Delete Query that checks if the primary key "Is Not Null" and deletes. I've tried running the query based on many other parameters, but I always recieve the same error: "Could not delete from specified Tables" any ideas...

So we have a large Oracal DB that is going to do some rather complex data crunching and dump a report in an XLS format into a network drive every 30min. I am tasked to build an Access DB that can then look at that data and present it in a more readable form. The first, and most annoying...