Recent content by talia679

I didn't create it ... it's a database that has been in place for ages here ... so I'm guessing no ... but it's not something any of us here created.

I have these massive databases I need to export into CSV format ... but when I do that I lose the data that is included via an Input Mask. Example: The field titled BOX has an Input Mask: "PA"99999 but when I export this table I lose the "PA" Is there a way to export to CSV & keep this very...

Is it possible to have hourly Column Headings versus whole times or days or months in a crosstab query. What I need to find out is how many people are logging in between 12-1 between 1-2 and so on. So I was picturing something like this: ..................8.....9.....10.....11.....12...

That is GREAT! ... I can't believe I never even noticed that before. I guess we don't always look for the obvious answers. Thanks for the help. Did just what I wanted.

I didn't know a better way to word that subject for you all ... here's what I want. I have Table A & Query B both contain a field entitled Username. I want a query that only shows me Usernames that are present in Query B but not Table A. Here's what I had. Field: Username Table: Query B...

:( ... they can't be linked. One is on out Intranet and one is on our Extranet ... the people outside can't access our Intranet and if the databases are linked it causes all kinds of permission problems ... let me see if I can figure this out using that TransferDatabase option ...

Okay I read ... and it all seems pretty simple except that I want to be able Import the Query (the data output of the query) as a Table. And I want it to overwrite any Table with the same name. None of this was in the help ... Here's the steps I need to complete Open Database 2 Import...

The date is the column heading and it's not showing the info ... if there's more i need to do to "set it up" then I need to know how to do that ... All i know is to set the crosstab to column heading ... which it is as you can see by the image.

I have two crosstab queries that do the same exact thing for two different queries, but they aren't appearing the same. View the attached image to see how they are set up. When I view the top one I see all of the months from jan - dec even though there is no data for the future months. When I...

Okay ... so is there a specific way I can do this? So that it's automated? or so that I just hit a button that runs the script and it takes care of it? I know how to manually export the data of the queries into tables in another data base, but I know nothing of modules or macros.

Sorry ... wasn't sure how to word what we wanted. Okay I think we want option 1 "export the data return of 3 queries to a spreadsheet, file, or other Access database" But I want the data return of the 3 queries to exported into 3 different tables within another access database. The user is...

This is going to be a hard one to understand. I'm not sure if it can be done with macros or modules or even at all so I'm categorizing it as General. Here we go: I have this HUGE database (Access 97) to store all of our web stats for every web page our company controls. In this database I...

One more thing About the date - can I format it so that it shows up mm/dd/yy ... instead of m/d/yy ... I don't see a way to do that in a query ... I know how to do it in a table ... hmmmm

THAT IS AMAZING!!! Thanks so much ... I have but one more problem: Date: DateSerial([Month]+1,[Day],[Year]+1900) This is how the date is computed. Right now it shows 0 for January and so on and 102 for the year. However I can't seem to get it to calculate right ... this makes the date...

Okay did the looking up ... even installed the complete help file (cause I didn't have it) but now that I've read the help I realize I don't remember enough VB to do something like that. This is what I wrote based on the example: Dim FixTime FixTime = TimeSerial(Tables![Log]![Hours]...