Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Microsoft Access


Access/Oracle Link HELP!  

I was hired to write some reports in Access 2000 for a small company (max of 6 users at a time). The database was created by someone else and he decided that moving to Oracle was the answer to some of their issues (losing data due to record... Continue Reading
Views : 55
Monday 22nd of October 2012

2 questions 1, move record to a new table 2, prevent changes to design  

1) HOw can I move a record from one talbe to another when a specific drop-down option is selected. Example: a combo box with "Active"; "Pending"; "Closed" I want all closed recoreds in a table just for closed records to reduce clutter. They're not going to be referenced often... Continue Reading
Views : 87
Monday 22nd of October 2012

No error code  

While stepping through some Access VB statments at one point I come to a line which is; Code: ... Continue Reading
Views : 63
Monday 22nd of October 2012

LDB File won't close  

We have a couple Access 2000 database's that are updated from Oracle data each night. There is a routine that opens Access, updates, then closes. However, on numerous occations, when it closes, the ldb file is still there. I can not delete the file without rebooting the server... Continue Reading
Views : 50
Monday 22nd of October 2012

Duplicate a form and sort a form in ascending or descending order  

Hello,Is their a a way I can have a button or something in which duplicates all the data in the text boxes instead of re-entering data? Also how can I sort data (DATES) that is in a form in descending order.Thank you,Onofrio ... Continue Reading
Views : 69
Monday 22nd of October 2012

Export to DBASE III  

I need to export ms access table to dbase III format.When I use export something is missing and the file format is just not good.When I try to open dbf file with program Dbase I get message "not a dbase database".I find out that excel do the same, so if... Continue Reading
Views : 37
Monday 22nd of October 2012

Database Modelling!  

I wondered if you might be able to help me with a database problem I have. I'm doing this in access so I've attached a copy of the relationships window. This database is suppose to store stock levels and orders for a chain of stores that all stock the same products.... Continue Reading
Views : 65
Monday 22nd of October 2012

Create RSS-feed from Access database  

Hi!Ive already got a news system that im very pleased with. The only problem is that it doesnt support RSS, something i aim to implement. Does anyone have any tips or code to best get an RSS 2.0-feed up, pulling the latest topics out of an MS Access database? Continue Reading
Views : 53
Monday 22nd of October 2012

Deleting Blanks  

HelloI have a back-end database which imports a spreadsheet which is automated. Every-time the spreadsheet is imported a large amount of blanks appear above the information i require.Is there away i can automatically stop this from happening? Continue Reading
Views : 54
Monday 22nd of October 2012

Query Criteria  

Hello, I need to create a query from a table, which has two fields that may have similar data.One field is named MBA the other MBP.I need to pull out all records that are showing the same valued in the above fields. Any idea? Thanks. Continue Reading
Views : 38
Monday 22nd of October 2012

Apply Filter from subform to Form by DATE  

these lines: Code: DoCmd.OpenForm strForm, acNormal, , strWhere ' for date DoCmd.OpenForm strForm, acNormal, , strWhere2 ' for date ... Continue Reading
Views : 73
Monday 22nd of October 2012

search form with option buttons  

Hello,I have a form named Welcome which I want to use as search menu for my database.I have added 4 option buttons and a unique textbox into which users will write their query criteria.My database has 4 queries and each option button should refer to one of them... Continue Reading
Views : 84
Monday 22nd of October 2012

Address Block  

I have a form for all my clients, and currently there's a separate field for each part of the address. This does not make it easy to cut and paste an entire address block. I therefore created an unbound text box with the control source as: =[FMT-NAME] & Chr(13) &... Continue Reading
Views : 49
Monday 22nd of October 2012

export as csv file  

Dear All:I have a query with Student ID numbers. These numbers are listed vertically.I wish to export these numbers as a csv file where there are commas after every Student ID number while keeping the vertical format.Any ideas? Continue Reading
Views : 125
Monday 22nd of October 2012

unbound report - setting control values  

I have a very simple report - just one field.I have a Form - "Cases". The button to open the report is on that form as are the values I want in the report.I want to pull the value of Case Name and Case Number from the current form view and put them... Continue Reading
Views : 74
Monday 22nd of October 2012

Case select to run queries  

Please help with the code below. I am trying to select a different query based on the selection in the [Product] Field. I have 4 different products and 3 different queries to run. Each product is specific to a particular query.What I would like is: Continue Reading
Views : 78
Monday 22nd of October 2012

Can I use a Data Access Page for this  

Hi I routinely use the results from a .php script on a public website in my job and am trying to automate that lookup and store the results into an Access 2003 Table.What I'm wondering is can I use a Data Access Page to do this? Basically I want to be able to have... Continue Reading
Views : 58
Monday 22nd of October 2012

Animated Gif Image  

Is there a way using the OLE Object type to get an Animated Gif to appear on a form? Continue Reading
Views : 56
Monday 22nd of October 2012

Javascript Popup Window  

I have created an asp popup window that is called by a javascript function from another asp page. The popup window is generated from a database. The code on the mainpage to generate the popup window is: Continue Reading
Views : 61
Monday 22nd of October 2012

get username of current user  

HiI have designed a MS Access tool accessed by multiple user. The first screen asks for badge number which is unique for each user. I wanted to do away with that screen. Instead wanted to get the username of the currently logged in user, may be from registry or somewhere. ... Continue Reading
Views : 73
Monday 22nd of October 2012

conditional formatting on continuous forms  

I have an accounting database with queues that list each requisition's important information (ID, vendor, dates, etc) plus the its status (not yet submitted, approved, ordered, delivered, filed, etc).I'd like the font of the status field to change color depending on... Continue Reading
Views : 90
Monday 22nd of October 2012

Online Tutorials  

Hey guys,I was wondering if there are any online tutorials you know of on the subjects of table relationships and normalisation?Any help would be great Continue Reading
Views : 38
Monday 22nd of October 2012

Textarea: new alinea, also in display...  

I have a question about entering text in a form, which is being saved in an Access-DB (DataType is Memo). You must think about a description-field for entering an item in a database with real-estate-properties.Even when the text which is entered in the textarea with... Continue Reading
Views : 36
Monday 22nd of October 2012

.DBX files Linked to ACCESS DB  

I'm trying to link .DBX files to an ACCESS database. My problem is that the Dates are in this format. "20040123" and times are in "730" or "1630" and, all fields are TEXT. The Database is being used to help analyze production times and employee dates worked, so you can see I need... Continue Reading
Views : 58
Monday 22nd of October 2012

Password issues  

A disgruntled employee left the company and placed a password on the Access DB. Is there a way to remove it? Continue Reading
Views : 45
Monday 22nd of October 2012

Between Dates function  

Hello,I have a form with two text boxes. One, named txtDOB returns that age of a person. The other control is simply named txtmsg.I would like to add a code to the OnChange event that provides a message based on the range of dates entered in the txtDOB... Continue Reading
Views : 50
Monday 22nd of October 2012

Same Criteria - Multiple Queries  

I have multiple queries pulling data from multiple data tables but are all common by a date that I have to enter in the criteria field for each query each time I need to change the date. Is there a way for the criteria field to read data (the date I want) from somewhere so I... Continue Reading
Views : 45
Monday 22nd of October 2012

Displaying Image in a form/report  

I have a form in which I want to retrieve images from a folder. Each record contains a txt field where the path of the image is located. Not every record contains a path to the image file as some records does not have images. I have created an image field in my form and used... Continue Reading
Views : 78
Monday 22nd of October 2012

Report  

I have created a database and all its reports. I want ask for reports for specific date ranges, How do I do that?L A Gandy Continue Reading
Views : 36
Monday 22nd of October 2012

Combo Box - Default Typing  

Hi all...I have a combo drop down box that has the 50 states in it. I would like the list to pop to the first state that starts with a letter typed in. For exampe, you type 'C', takes you right to CA.Anyone now how to do this? (silly question Continue Reading
Views : 44
Monday 22nd of October 2012