Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Microsoft Access


Print Record from Form...  

I've got an unbound form that view records indvidually and I'd like to create a report that when the end-user selects the Print Record Command button it will print all the employees information for his review and if changes my admin's will make the changes. What code would i use... Continue Reading
Views : 59
Monday 22nd of October 2012

Single page form and mouse scroll wheel problem.  

Is there a way to prevent a user from switching records on a single page form when he rolls his/her mouse wheel. I have noticed that users accidentally scroll the wheel, and this switches them to the next record. I need for them to remain at the current record they... Continue Reading
Views : 199
Monday 22nd of October 2012

Run Time Error 3134 - SQL statement  

Good day,I was wondering if I can get some help with my sql statement, b/c I am a run-time error. I have attached my db but the statement is as follows:SqlStr = "INSERT INTO tblpcomaward (recempid, reclname, recfname, recdate, givempid, givelname,... Continue Reading
Views : 64
Monday 22nd of October 2012

CommonDialog control  

attempting to add the common dialog control as an interface for file operations. get error 'The OLE server isn't registered.' no other control that shows up under additional controls acts like this. also, isn't common dialog core to the OS? how do i get around... Continue Reading
Views : 75
Monday 22nd of October 2012

Database Design  

Hi, I?m fairly new to access and I?m creating (well, want to create) an employee database. I was wondering if anybody has created an employee database that keeps track of employees information like; personal information, salary,... Continue Reading
Views : 88
Monday 22nd of October 2012

how to create a horizontal line across the access chart  

Hi, I have to create a horizontal across the chart whereby the y-axis value is 1500. Can anyone help me? Regards,Dawn Continue Reading
Views : 133
Monday 22nd of October 2012

Split DB  

I know that this might be extremely obvious to most people, but at the risk of sounding stupid I'm going to ask it anyway. I plan to share my split DB over the network. I know that the BE will be hidden from the view of most people so they won't try to meddle with it, but which... Continue Reading
Views : 60
Monday 22nd of October 2012

Record Disappears.  

I've created a form and when i create a user it goes through without a problem. However when i try to create another user, my code somehow deletes the last record. Where am i going wrong? Code: Continue Reading
Views : 58
Monday 22nd of October 2012

Getting a textbox to populate based on another textbox  

Dear All: I have created a form using access 2000. So far, this form already has data and dates in a combox in this format: mm/dd/yyyy. In the AfterUpdate of the date combobox, I did this: If graduation_date = #2/1/2004# then Continue Reading
Views : 94
Monday 22nd of October 2012

Web Help  

Hi, I am a student in Ireland doing a final year project that involves database entries that need to be updated online.I have created a switchboard in Access 2000 which edits multiple tables but now I need to find out if I can publish and access this same... Continue Reading
Views : 49
Monday 22nd of October 2012

Query question  

Is it possible to use a drop down menu to pick a customer that I want to use for the query Customer criteria to run a query for an invoice report? Right now I have 4 different queries for 4 different customers to print 4 different invoices but I realized that I will be adding a... Continue Reading
Views : 68
Monday 22nd of October 2012

Open DBF Files in Access  

Hi All,I am trying to open a DBF file in VBA, I get the an error:Run-Time error '91':Object variable or With block variable not sethere is my code:'-------------------------------------------------------------'Dim oConn As... Continue Reading
Views : 68
Monday 22nd of October 2012

update column valu with random number  

hello allI am trying to set column values to a random number between 3 and 5 PMRating TokenID: textH1: doubleYearID: text Continue Reading
Views : 86
Monday 22nd of October 2012

Form won't accept new data  

I have created a form based on a query that joins two tables. When I run the form, I am able to input new data into all fields that are from one of the two tables, but it won't accept new data into the second table. I don't get an error message that might help me identify the... Continue Reading
Views : 79
Monday 22nd of October 2012

30 Day Demo Limit  

I was able to get a response to a question on sorting records which was great. So I've decided to post one that I am concerned about. Once I have completed my DB, I would like to send this out for review. How do I limit the viewing to a 30-day demo? Once the 30-day... Continue Reading
Views : 80
Monday 22nd of October 2012

Forced Shutdown at Time()  

I am still learning access and have been helped alot by this forrum so I thought someone may be able to help me here. I am trying to experiment with security from a few different angles, privileges to folder, to database, inactivity shutdown, ect. I know that my office shuts down... Continue Reading
Views : 81
Monday 22nd of October 2012

Displaying data from two databases that have a common field  

I'm a complete novice when it comes to dynamic data so forgive my ignorance. My database contains details of projects in progress. A user can click a link in a list anddisplay a summary of that project (okay so far - I've done that bit) - in the database though... Continue Reading
Views : 94
Monday 22nd of October 2012

Primary key problems  

Hello I have a form that is bound to a table . The table's primary key is the problem. When I use the form to add new records, If the user "accidentally" enters nothing in the field that is bound to the primary key of the table, or enters a value that exists in another... Continue Reading
Views : 87
Monday 22nd of October 2012

Open only forms// I need Help  

hi i am new in Access and i make one project with it.Now i need when i open the indexForm i want open only it and not the access with table,queries,reports and access menu. Continue Reading
Views : 97
Monday 22nd of October 2012

Images in a report  

Dear All: I have created a report in access 2000. What I wish to do is insert a signature on this report and as I scroll through the report, the signatures change. The fields on the report are name, major and dean. The signatures reside on the "c" drive... Continue Reading
Views : 94
Monday 22nd of October 2012

Reusing info on a form  

Hi, I have a from which is based on a simple query. It prompt users to enter a booking number and then shows all info they have previously entered themselves. I did this in order to give them te opportunity to alter the info they've entered earlier.... Continue Reading
Views : 86
Monday 22nd of October 2012

Network permissions for a split DB  

I'm running a split DB over the network, and all of the users in past un-split DB's have to have permissions granted or they can't open the DB. My question is, if I'm running the BE and FE on the server, do permissions have to be assigned to both the FE and BE or is it enough to... Continue Reading
Views : 90
Monday 22nd of October 2012

Seeing certain records based on a checkbox  

How would I get a report to only show records that have a check box called "Display" checked? I have tried some code, I even put it in a couple of different places, but it still doesn't work. I put the code on the on click event of the command button that opens the report and I... Continue Reading
Views : 85
Monday 22nd of October 2012

Editing a ASP dynamic list menu in Dreamweaver linked to an Access DB  

I have to translate a dynamic list menu in a asp page, but the ?menu seems not to get the displayed selection labels from the database. Is there other way to source for the menu labels? and How can I chage these labels. here is a link to the page and the... Continue Reading
Views : 100
Monday 22nd of October 2012

Check Boxes  

If a check box is true/checked, how do I make it invisible on a report? Any help is greatly appreciated. Filipina Continue Reading
Views : 68
Monday 22nd of October 2012

Run-time error '13' Type mistype  

I created a Duplicate command/macro on a form and, when it is clicked on, a message appeared 'Run-time error '13' Type mismatch'. Debugging the... Continue Reading
Views : 60
Monday 22nd of October 2012

update a form by selecting from a combo box  

I have an unbound combo (because it is synchronised with another unbound combo box) box that selects a record, but I can not get it to update the rest of the form to show the required data.The form looks up project data from 3 seperate tables which are all linked by... Continue Reading
Views : 84
Monday 22nd of October 2012

Strange Report Error  

I have a database that keeps track of street light inspections. There is a form with inspection info and a subform with any faults found - Works Fine There is a report with the same information - Works Fine'ish The report allways used to work... Continue Reading
Views : 66
Monday 22nd of October 2012

User Authentication !!!  

Hi All,Im a beginner in Access.I created 2 tables-First one has the User-ID , Password and other details, Second table has All the personal details of those users.I have created a form with 2 text boxes and a button. The User enters his ID and Password and "Submits" it. Continue Reading
Views : 58
Monday 22nd of October 2012

To upsize or not to upsize, that is the question  

I have a dilema, my db is hosted on our shared drive, and with +-15 users at any given time there shouldn't be a problem. However, quite often the users get the message that they cant log on because the file is already in use. This will pose a bigger problem very soon, because... Continue Reading
Views : 63
Monday 22nd of October 2012