Search results for query: *

I like the format of the calendar in the first link, but I can't get into to populate the dates when I enter a month/year comibnation. Maybe I'm not copying it into my database correctly??? Has anyone else tried this? Suggestions?

I have a database shell I've created with contacts, inventory, etc. information. I'd like to add an interactive calendar form if possible. I haven't found this information on the net to date, but have seen some access databases online with the capability. Does anyone have advice as to how to...

Perfect. Thanks all!

Thanks John. I tried the unique records only, but that didn't create the output I need. I need the only serial numbers that are present in the list once, those that are duplicated, and their related information I do not need. Any ideas from here? I tried to think of a way to do this in access...

I have a spreadsheet that list several different pieces of data. The spreadsheet looks as follows: Cust Serial Date Amount Type 123 0656020652501 20060721 $115.82 P 123 0656020653011 20060724 ($40.12)X 123 0656020653011 20060721 $40.12 P 123 0656020658301 20060721 $10.18...

AH! I can't believe I didn't notice that. Thanks Jeff!!

I am creating the file from JCL, using the output name of: S:\all\ep\338.jcl.txt, which is a network folder. I have tried importing the file by using the access import wizard. I receive the error message when trying to import or link the file.

Yes. When I created the output file I gave it the .txt extention. Were you able to find an extension that worked?

I am attempting to import a large text file, created using JCL, into Access for manipulation. When I open a new database, and attempt to import a new table I receive an error message stating, "The Microsoft Jet database engine could not find the object '(path.txt)'. Make sure the object exists...

Is anyone aware of how Hot Keys can be created in Oracle 11i. It sounds simple enough, but I can find the answer. Thanks!

Thanks! This worked perfectly.

I have several tables, that when imported from our AS400 system, convert the date as Julian values. I would like to add a formula to a query that converts the Julian format into a legible date format. Any suggestions? Here's an example - TM_DATE_EXPIRED_JULIAN_1 = 110365 The true date is 12/31/10

Works great. Thanks!

I am trying to create a query that will find numbers starting with a certain location zone, and ending with a certain location zone. Data- 925-266-161 912-274-010 925-176-010 I need the query to gather data that starts 903-913 and ends in 010, like 903-xxx-010 to 913-xxx-010. Then the query...

Blorf- Works good! Thanks all.

I need to create a calculation that will return a positive number. I have a form that compares two fields: actual inventory counts and original inventory counts. I would like to take the difference of the two fields and divide that number by the actual inventory count to receieve a percentage of...

Hi all- I have a subform in my database that pulls information from an inventory system. This subform should not be changed by the user of the general form, but is viewed by them for reference. Is is possible, for data entry, to set up the tab order such that it does not tab into the subform, it...

WOW! I didn't think I would get this much of a response. I finally finished my report! I ended up using ideas from a few suggestions. I filtered out the year and I set up a bins_array. I tried a lot of other suggestions and learned some new things along way. Thanks to all! Seth

I wansn't sure what to name this thread as I am not sure how to solve the problem. Here is what my spreadsheet looks like: Column: C E 1-2-00 $16.50 2-4-01 $11.25 6-10-02 $10.00 etc. I have several rows of data and I need the formula add the dollar amount...