Search results

I figured it out, never mind.

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 1 problem I have with your idea is that I DONT want the user to be able to edit that subform other than with the button. Also, what VB code do I use to create a new record in a subform that's in continuous forms mode? It lists all matching time stamps based on ticket number. I just want to...

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

ok, wierd... it worked twice and then now it doesnt. GRRRRR edit.. ok, no it works. I had an error elsewhere in my code. SentOnBehalfOfName is what you want.

GOT IT!! wooo! olItem.SentOnBehalfOfName =

that just returns an error. I looked it up... that that property is for incoming mail. You read it to see where it came from.

Here's what I have... it works... but I can't figure out what the from field is... Public Function CreateMailItem(strTo As String, strSubject As String, strBody As String) Dim appOutlook As Outlook.Application Dim olItem As Outlook.MailItem Set appOutlook = New...

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

My question is, how do I make the link table? I want to list ALL of these records. Under names I have about 300 entries Under Cloths I have about 20 entries I have to enter this by hand?

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

Ok, thanks! I'll check that out. By network, I didn't mean like computer network. It's a broad number of people reporting problems with equipment that is interconnected over a large area. Again, it's rather complicated and really not important to the statistics at hand so I'll just leave it...

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

figured it out... "Set the UniqueRecords property to Yes."

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

OH... I have to link the fields? ah... I didn't do that. I will try it out.

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