Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Microsoft Access


Export query to Excel  

Hi there, I have a button on a form and when I press it I would like this to happen:Some code will be run that makes a copy of an templatefile (Excel), puts the values that comes from my query into the document and the saves it with a name that comes from two... Continue Reading
Views : 257
Monday 22nd of October 2012

help please  

I am writting a macro in acess that will open and update an excel worksheetI am trying to use thr RunApp but do not know how to word the commandlineI have tried to put open c:\my documents\checktest and have changed the word open to run but get the same error... Continue Reading
Views : 67
Monday 22nd of October 2012

Ole  

Hi allMy concept is to link a bunch of files on my hard drive into a searchable databaseI have an unbound form with a bunch of fields. I have (at the moment) a bound OLE field that I'm using as the link. I have a command ADO button to add records. But... Continue Reading
Views : 36
Monday 22nd of October 2012

Mirosoft Access Help I'LL PAY  

Guys I have some assignments that I need help with, I have never taken any Access Courses before. I have like 4 assignments to complete, I'm willing to pay someone to do it for me, they are very simple I just dont know anything about Access, never used it before. I cant drop... Continue Reading
Views : 41
Monday 22nd of October 2012

Creating database documentation/help  

Hi I need to create a documentation - help system in my Access database. Can you give some guide lines and tips? General of course... like how to link a help file or something like that... Continue Reading
Views : 68
Monday 22nd of October 2012

Passing value in one-to-many relationship  

In my accounting database, I have a form for the requisition and a subform with the line items of the order. When a user has completed their changes, they click a button which closes the form and changes a value in the main table (as in the requisition status is now "submitted"... Continue Reading
Views : 60
Monday 22nd of October 2012

changing combobox value  

I have a combo box with an SQL rowsource. How can I automatically select the 'next' value (through VB) within the same combo box? Also, I will like to display a message like 'This was the last record' in case there is no 'next'... Continue Reading
Views : 99
Monday 22nd of October 2012

How to output records into list box with 3 coloum headings  

Hi every one. i want out put records into a list box with 3 column headings named as playerno, initials and name. The way i created the list box is by putting list value for the row source type and name the list box as lstPlayers. But unfortunately get all the the records Fields... Continue Reading
Views : 76
Monday 22nd of October 2012

Passing values  

I need to find a way of passing a value from an Access form to an .asp page... Page1.asp is viewable on the web and asks a user for a code and password - these are checked against a database and when a match is found page2.asp is opened showing values based on SQL... Continue Reading
Views : 54
Monday 22nd of October 2012

export single field to text file  

Anyone have any idea how i would be able to export a single cells content (from a query) into a txt document without headers or extras? What I'm essentially trying to do is view the cells content (which is in html) in a web-browser.. Any Ideas?... Continue Reading
Views : 115
Monday 22nd of October 2012

Matching name differences  

Hi. I am in the process of loading nursing license numbers into my database. The spreadsheet that I am importing from does not use the exact same names as the ones in my database, i.e. Smith, Deb in my database is Smith, Debora in the spreadsheet and I can't figure out the code... Continue Reading
Views : 64
Monday 22nd of October 2012

Link failure to MySql table  

I have a table sitting on a MySql database. I want to access that table from within Access. I have set up an ODBC DNS for the MySql database, and everything is fine, except for one really large table. Whenever I try to open that table, or query that table, all the fields show up... Continue Reading
Views : 63
Monday 22nd of October 2012

FormatNumber  

I am trying to use a query I made with a newer version of Access on an older one. The older one does not recognize the 'FormatNumber' function and I believe this has to do with the fact that it uses the Microsoft 9.0 Object Library. Is there an equivalent to the FormatNumber... Continue Reading
Views : 63
Monday 22nd of October 2012

Why is this not working  

Hy,i've got three tables:products:product_id,product_namemonths:month_id,name_of_monthcalculations:calculations_id,month_id,amount Also have this query: SELECT DISTINCTROW products.product_name, Sum(calculations.amount)... Continue Reading
Views : 47
Monday 22nd of October 2012

Summing in Query by multiple characteristics  

I'm trying to sum revenue by unit by program by segment but it's seem to be summing it by all units or all programs. my joins are the first option egaual to both tables. it's a select query and only has two tables. the unit, program, segment are all 'group by' and the... Continue Reading
Views : 38
Monday 22nd of October 2012

How to create a search form in msAccess  

I am using msAccess to develop a small application.I have 2 tables, student and course, and I need to create a form with 3 fields - by_id, by_date, by_course_id This form can generate a view only table according to the field the user entered. ... Continue Reading
Views : 95
Monday 22nd of October 2012

exporting to excel  

I'm trying to export some information out of Access into an excel spreadsheet in a paticular format. When I run the code it will give me the following error about every other time, Application-defined or object-defined... Continue Reading
Views : 92
Monday 22nd of October 2012

Math Operations on Values Question  

I have created a table that holds the inventory information of some items i have in stock. What I want to do is this: 1.)When a customer orders something, i enter the quantity ordered and hit a process button. When this button is clicked it automatically reduces... Continue Reading
Views : 49
Monday 22nd of October 2012

MS Access Log in and Security  

Hi there, I have a database which I created for usage of all company people. There is a main menu form which directs users to their own log in form with passwords. The users can only access the form.But as administrator, I want to have full access to the database. How... Continue Reading
Views : 48
Monday 22nd of October 2012

Counting by Date Ranges  

I received help on previous threads. Basically, I have built a query to group by course title and then select the number of students that were assigned a course during a specifc time frame. Is there a way to show multiple columns in the query. For example my query now shows,... Continue Reading
Views : 66
Monday 22nd of October 2012

Better Way to Go With Forms and MDB  

[ solved ] Hi Gods : ) I am a beginner in this kind of thing... and I am trying to make a form to send the data to a MDB file and send the data throu mail. Until now, everthing is working fine... but know I... Continue Reading
Views : 77
Monday 22nd of October 2012

Search Listbox as you type in textbox  

hello guys! i hope you can help me with this. can somebody show me how to do this in access? here is the link of the VB version. http://www.codeguru.com/ Continue Reading
Views : 74
Monday 22nd of October 2012

VLOOKUP equivalent in Access (Dlookup)  

I am an intermediate level Access user and I am trying to have one of my tables lookup data in another table and populate the corresponding data. For example, TABLE 1 and TABLE 2 both have a common field, MATERIAL field. TABLE 1 contains a SERIAL CODE field which is all the... Continue Reading
Views : 45
Monday 22nd of October 2012

Disable / Option Group after update  

Hi, Newbie needing a shove in the right direction. My option group will be confusing for a user because it defaults to the Male selection of the Male / Female option. In other words, as the user views the form to scroll through the records, the option button will... Continue Reading
Views : 121
Monday 22nd of October 2012

WScript  

I'm trying to create an import proceedor to an application from an access db I created. The application's company sent some information of doing this is vb. Since everything is in Access I thought I could just put the code behind a button an... Continue Reading
Views : 41
Monday 22nd of October 2012

Invoicing Sums  

I have a report that is broken up by invoice number. I want to create a text box that will sum the lines for each invoice number. I have the text box set to add the lines, but currently it is grabbing the first value for each multiple line invoice. Confusing, I know. See... Continue Reading
Views : 71
Monday 22nd of October 2012

change column names  

Can I edit a column nameto show a different name than in my table as a heading? Continue Reading
Views : 62
Monday 22nd of October 2012

VBA for Access tutorial  

Does anyone knows a good VBA for Access tutorial or documentation i can download so i learn how to write the Event Procedures in MS Access? Thank you for your help. Continue Reading
Views : 34
Monday 22nd of October 2012

What to do next  

I have set up my Access database, tables, relationnships, queries and forms.Now i can enter new, or read and display information. But:I dont want the user to open Access everytime they want to input new information and all, b/c the user will get lost in forms and... Continue Reading
Views : 41
Monday 22nd of October 2012

Determining appropriate Const MaxRecords  

I have an ASP / Access storefront, connecting through JET OLE, which is frequently crashing with '800040005 System Resource Exceeded'. The whole ODBC/Jet service must be restarted by my host manually. Usually this error indicates an unclosed rs.open. I have however... Continue Reading
Views : 59
Monday 22nd of October 2012