Search results

Hi, I have a combo box on a form which displays records in a subform (datasheet view). the combo box is a list of containers - And the subform shows the different products numbers that are in that containers.. Now, sometimes the user is required to know on which container was a particular...

Hi guys, I have been using access for few months now and I have learnt great things thanks to google and this forum. I have made a simple application and I am currently distributing .accde version to the multiple users. All works fine. However, some old applications were built by this...

works! thanks a lot buddy.

but I different users should be able to open the database at the same time as well. It is shared over a common drive.

Hi guys, I have a form on a database - This form has a button which, when clicked, opens another database for the user. I want the button to set focus to the database if it's already open - Here is the code I have so far: Private Sub Command1_Click() Dim appAccess As Access.Application...

There is 1 file per day. but is there a way to find the creation date only? I have been googling this since last night - i know access must have another way to solve this :S any clues? Thanks guys!

just a question: filedatetime shows the time a file was created or last modified. Since a file might be modified after it's creation date, is there a way to compare txtDate with just the creation date?

Jdraw: Yes sir! the txt files are to be imported into their seperate table - which gets overwrriten every week. pi6 - thanks for the code. i'll play with it and keep you posted. Thanks guys!

Thanks for the reply jdraw! the thing is - these files are thrown in this directory by a host system. The name of the files are similar but with the date changed. so today's file name is Locations20120315.TXT yesterdays = Locations20120314.TXT and so on. Now on Mondays, I want to be...

Hi, Here is the situation: I want to import 3 recent txt files (based on date and time) to an access table. Each txt file is to be imported to it's table. These txt files are located in a directory which is populated everyday with new txt files, hence the txt files keep changing. A...

I change the code, but it gives me an error "Expected end of statement" - What's wrong?

Hi, I want to open a database application, shared among the users on a common drive, by clicking on a button on a form in another database. So far, I have been using Private Sub Command0_Click() Dim strDB As String strDB = "C:\Documents and Settings\umair.khan\Desktop\PC-Docs_FE.accdb"...

thanks! that sounds like a reasonable approach. I guess I can start documenting and make changes as I go.

Hi guys, so I need to document the entire database so It can be used and looked over by any future employee. I tried to run the database document option from Access 2007, but it crashes everytime I run it. also, the information from there is so wide and broad. Just asking opinions here...

Hi, I want to import a query from Access 2007 to Excel 2007. This query is regularly updated, so I want to see the changes in the excel worksheet as well - Basically, everytime I run the query the excel worksheet should also get updated. anyone knows how to work this around? thanks :)

Hi, the attached is the raw data I have in excel - I want to create a chart for this information. I created a line chart, but I don't think it's appropriate for this information. I want to be able to display "Total actioned" information stacked over "Total Available" for each activity...

=)))))>=B2,0)) Thanks alot NBVC!! just had to include an "=" sign in the code. so if QTY_ON_HAND = SUMOFUNITS1, then it should give SUMOFUNITS1 as the answer! thanks again!! much appreciated

Hi guys, I am attaching a spreadsheet here - what I want is to list the products in order of when the QTY_ON_HAND is depleted. so for example: for product number 0090069, the QTY_ON_HAND = 442 SumofUNITS1 = 125 SumofUNITS2 = 75.3 SumofUNITS3 = 101.1 SumofUNITS4 = 134.5 SumofUNITS5 =...

Thanks! that's a good idea actually!

I know! and I am working on my database on the side as you suggested. As I mentioned in the first post, this is not my database. They just handed me a table and asked me to do some "analysis". Unfortunately, every access application in here is not normalized, so I guess I'm up for a ride :/