Search results

Hello forums. Using access 2010 here. Trying to setup a database that would allow me to create purchase orders, and then receive the items within that purchase order I think I got the purchasing side of it setup properly, but i'm having trouble with the receiving side of things. For the...

Does anyone know of a way to read the name of the currently open file in excel using VBA? I've tried the Application.Getopenfilename, but that brings up the Open file dialog which I do not want. If I'm editing a file called "Sample-sheet.xls" I need a way to find that string in VBA Any ideas?

Situation: I have a VBA function that collects information from the current excel worksheet and some text files on my system. Uses this information to generate an email, and attaches a copy of the current worksheet to the email. All works fine, and it really works wonders... saves me a ton of...

Is it possible to trigger a macro when exiting / updating a cell in excel?

Hi, I need help figuring out how to do this I have a template that I use a lot. From this template, I save the filled out .xls into a separate folder to keep for our records.... What I want is a way to do away with typing the same information over and over... so I have like 50 shipping...

Hi, I have an excel template that I use every day.. pretty much the same routine.. Update the date field, make the necessary changes, attach it to an email. I thought it'd be nice to create a bit of VBA code to do the routine stuff, so I did. I have added a button on my toolbar which has...

I have a couple of fields in a form which are either calculated fields or get their values from another place(a subform). I need a way to "sense" when the values of these boxes has changed (the user never changes these values) Any idea?

I have a form in which I enter information to create a purchase order. The Main form has basic information, like vendor, shipping location, job, po number etc. There is a subform that links to another table which records the items purchased on that one PO. I have a button that when I click...

Again.. need help here. I have a form that generates a report from a table that contains a list of purchase orders. The fields in the table go like this [PO Number] | [DATE] | [Vendor] | [JOB] In my form I have added a textbox and formatted to a short date (1/01/1980). so what I'm looking for...

While developing this database, I wanted to try the splitting thinng... so I split my database into front and backend. But I'm still developing this thing... so Is there a way to put it back to gether? I will need it split, but later on... not now and I dont know how to put it back. Any...

I need to create a report based on a query using multiple criteria. Here is my example I have a table with several records of purchase orders. [PO Number] | [DATE] | [Vendor] | [Job] I can run a searh using the job or vendor fields using the following line DoCmd.OpenReport stDocName...

I'm trying to create a query based off a table. Is it possible to create a calculated field in a query? For instance, the table has fields for QTY and PRICE Can I create a field in the query to multiply these 2 values without adding a field to the table? If so, how is this done?

I'm trying to get the user name value on a form I know you can user Environ("UserName") but that gives me the login name (the name used at the Windows login prompt But instead of that, I want the name displayed on top of the start menu in win XP Anyone know how to get this name?

I want to set up a double-click event for an object and I want it to open another form. I've tried Forms![Name_Of_Form].activate but the debugger keeps saying it can't find the form I'm specifying. Anyone know how this should be done?

Form to search table help please - updated I've created this form th at has a combobox. This combobox is populated from a table that only has 2 fields, Key and Category. I've also got a listbox right below it. This listbox is to be populated from another table called PartsList with the...

Anyone know if it's possible to generate a PDF from a report? or some other type of read-only document? I'd prefer PDF, but I'd settle for a read-only spreadsheet or word document

I have a table that has a bunch of data. I'm already using this data on forms and my database is turning out great (thanks to the help I got here) Now I have this situation... where this table will get rediculously long. This is the table that contains information about the things I buy with...

I'm working on a database similar to a sales databse (except this is for buying stuff). There are transactions, and each transaction has a lot of items in it. Think of this as an invoice... You have one invoice, and several line items in each invoice. I've designed a query that groups can...

I have a field in a form that I need help with. I want to set a default value for it depending on the time of the day the record is being entered. If the current time is 11:00 am or earlier, I want it to default to today otherwise, I want it to default to tomorrow's date any suggestions?

I need a way to do some conditional record locking. I'll try to explain. I'll be using this database that I'm building to order stuff from different vendors. The vendor will then issue an invoice to me. When this invoice arrives, I'll be checking for price discrepancies and that sort of things...