Export in cvs format

Hi I already do export some reports en queries in to an ..xls/rtf/tst/pdf-format. But my webmaster want it exported in cvs format. Is this possible? -- Luc Ringoir Belgium

Date

I have a table with a start date column. I have created a query where I include the start date from my table, I have created an expression to add 24 months to the start date but what I would like to also have is either the specific date or the closest month of May. for example Start date is July 1, 2008 if I add 24 months it will show July 1, 2010 What I would like to see is May 2010 as this the month that we identify individuals that need to start a secondary process. Very new to access and not that great with formulas -- Thank You Sassy

dates from Access > Outlook Calendar

I would like to be able to add events to a shared Outlook 2007 Calendar directly from our Access 2007 database. It seems fairly easy to do it from Outlook to Access (though I haven't tried it!) but I can't find anything straightforward for doing it the other way. We would like to fill in the event details in an Access form and then, if possible, have the basic date and times saved/ transferred/ whatever! to the Outlook calendar - simply to save the extra step of doing it manually. I have used Access for a few months but have not done any real coding - (someone in the Outlook

Test Possible Before Saving?

ACCESS 2007 If I have made some changes (for example modifying a field to make sure that values are required and / or creating a lookup for a field to name just 2 possibilities) is there a way to ensure that the above changes are tested before I save the changes I've made? TIA for any replies.

Selecting the last 10 records from a specific date

I have a date field and name field, I want to return the last 10 Name records entered from a specific date..... ie: Count back 10 records in the date field from Todays date and display the names from that date, to today.... seems really simple but I can't get it right...

Store info for reports from switchboard

Hello, im running MS 2007 and I need help with my form 'frmSwitchboard'. On my form I have buttons that open reports and some buttons require a selection from a combo box thats associated with that button. Now on the frmSwitchboard(s) button I am using; Me.Visible = False 'Hides the switchboard So I can use the information when the report opens and when I close the report I use; Forms![frmSwitchboard].Visible = True Which makes the frmSwitchboard visible again. My problem is if I open a report and choose to just close the DB all together I get the error; Run-time er

Ribbon

I have succeeded in using Albert D Kallal ' s brilliant code to control a Ribbon on a form. The only problem I cannot solve is how to make some buttons invisible when the form loads. If I put the meRib("btSearch").visible = False in Form_Active or Form_Current. I get the runtime error '2475' you entered an expression that requires a form to be the active window. Any suggestions would be great. -- Message posted via http://www.accessmonster.com

Thank You

I have been using this newsgroup for many years, and on each ocation I have always been received with a warm reception and you guys have always provided me with the best support. I just want to say thank you!!!! Bre-x

Error Message

Can anyone help please, I would like to get an answer to the problem before Microsoft close down the Forum. This is the message I posted earlier, for the full background to this, please read my post (and Ken Sherien's kind answers) titled "Sub Forms" dated 18 May 2010. Hi Ken Access bing Access, I was probably a little premature in my excitement at getting the thing to work. I now have a dialogue box that pops up as Access is first opening up and prior to the first screen being displayed saying :- "The exprexssion is typed incorrectly or is too complicated, For example, a

HOW CAN I CREATE SIGN IN SHEETS

how can i create sign sheets

Help with Function: Between Time

Hi, Why this function is not working? If a time follows between 12AM and 3PM it should show Day shift, anything else Night Shift If Time > #12:01:00 AM# < #3:00:00 PM# Then MsgBox "DAY SHIFT" Else MsgBox "NIGTH SHIFT" End If

Is it worth it for me to learn Access?

Hello everyone, I've been wondering this question for a few weeks now. My situation is that I generate many "runlogs" from my reactor that have various outputs, such as temperatures, sensor data, etc. versus time. Very frequently, I want to compare one runlog to another. Sometimes I want to average the output of several runlogs together. I currently have a macro made up in Excel that analyzes the files, but it really is getting harder to manage all the excel files floating around. So is it worth dumping all the excel output from my macro into a database and comparing th

Filtering Records

Hi, Problem : I have a DB table with 56 fields and form is on 1 screen. If I filter records I need result of filter to display in form view. I know it is possible in datasheet view - but it is not good for me because I need see all fields and in datasheed view with 56 fields it is a very long row an I have to use scroll bar for meny filds.. Any suggestion? Thank you in advance. lad5ko -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201005/1

Bill of materials

Hi. I need an Access (or maybe Excel) template to help me create bills of materials. A worksheet with a list of items (record) with the fields "Part number", "description" and "cost". I then need to be able create a BOM by entering the "part number" and have the "description" and "cost" as well as "selling price" (cost + profit %) calculated. Thanks in advance. Chris.

Saving Monthly Accounts and starting a new Month?

Hi Everyone, I really enjoy the Access Database System it has helped me a lot with my accounts but I must be doing something wrong because, I keep opening new databases for each month instead of it following on from the previous month and using the same "Categories!." So my question is How do I save the previous month and let it be stored, and start a new month on the same system or page but without adding up what has been put in the system... If you know what I`m on about. Thank you Angeldelight... melting in the UK weather :)

Keeping DB structure but adding new tables

Hi, I'm a complete novice just dibbling my toes in the water. I've been using Excel to analyse my data which I receive as .csv files. for e.g. School, Student and Exams. Each year the data is new as the students change. I've set up an Access database with queries from which I'm planning to create reports. Next year I would like to be able to just import the .csvs into a copied database and not lose the queries and reports etc. Is it doable and how would I go about it? Bear in mind that it has taken a lot of reading and trial and error just to get this far Many than

Inventory transaction table - set up

Hi, I am a new user of Access 2007. I am creating a database to track inventory quantities by locations. I have a Products table and a Locations table, and I am wondering what is the best way to set up a Transactions table. We have three types of transactions: 1. Move products from one location to another. 2. Introduce new products to a location. 3. Deplete products from locations. We would like to keep a record of transactions, by transaction ID and date. But the more important function will be to report on current Product quantities by Location. What fields should I include

I am using Window 7 and Access 2007

The trim function gives me a compiler error SortName: Trim([Members]![LastName] & ", " & [Members]![FirstName] & " " & [Members]![MiddleName] & " " & [Members]![Suffix] & " " & [Members]![Title]) The function works using windowXP & vista Any suggestions would be helpful.

How to make staff sales report and stock report

Dear All First table with names. second table with store items. I read the northwind for preparing invoices which does not fit my requirement. Pls give me links for me to read up on how to prepare report on persons who have made purchases by linking these two tables. Pls give any links where I can read on how to go about to prepare a report on persons who made purchases; report of stores opening stock, quantity sold and stock balance etc. Edit/Delete Message

Database replication using Access 2003 in Windows 7

I am running Access 2003 and have recently upgraded to Windows 7 from XP. I have created a database which uses the Replication function to enable several users in different locations to update data. Because I transferred the design master to a new laptop, I have had to recover the design master. However, one of the forms now will not open and I get a message saying that Access has stopped working and Windows is looking for a solution. The database then closes. The form contains tabs, although other forms that contain tabs work ok. I get the same problem if I try to open the form

Rounding Time

Hi, I am working on a Time Clock. I need some help to create two rouding functions. PUNCH IN TO between 8:00:01 to 8:14:59 8:15 between 8:15:01 to 8:29:59 8:30 between 8:30:01 to 8:44:59 8:45 between 8:45:01 to 8:59:59 9:00 PUNCH OUT TO between 3:00:01 to 3:14:59 3:00 between 3:15:01 to 3:29:59 3:15 between 3:30:01 to 3:44:59 3:30 between 3:45:01 to 3:59:59 3:45 Thank you All!!! Bre-x

Access - update existing table

Hi, i have a on going database for my employees and i would like to add another column employee ID number. On the existing table the column employee ID is there but no number associated to the employee. I want to import from excel. the excel file has all employees name and employee number. EE name is the primary key and i only want to import the EE ID number only, the rest of the column in the table leave as is. can someone help me with this? thanks

Report Totals

Can anyone help me please. I'm totally new to Access 2007 but have started to design a database for my husbands shed business. I have an Orders Table and a Supply Table. There may be several supply instances to complete one order. The report which I'm having problems with is Orders Part Supplied. I've summarised the important fields below. The report is grouped on Order No. Order No Qty Date Supp'd Qty Supp'd Total Qty O/S 10145 12 15/05/10 2

How to make an activity calendar for school travel and leisure 3 m

I need to make an activity calendar that has to do with travel and leisure for three months.

Database name added to link tables!

Hi, I am a very new Access database user. I am using the Microsoft Access function called “Get External Data” to create link tables to an Oracle 11 G R2 database. My problem is that Access is adding the database name to the names of all the link tables instead of just creating link tables with the original Oracle database name. Eg a table on the Oracle database is called “com_user” but is created by Access as a link table called “databasename_com_user” Unfortunately all my automated test scripts that use the Access link tables fail because they do not recognize the link table n