What is the syntax for creating a text file? I know how to do this manually using the menus but I'd like to put the language in a query (not a macro or...

Hi everyone, I've got a form where, if a record has already been exported (there's a yes/no flag for this), the flag is set to NO where the user changes the...

I added two new fields to a SQL table and updated the SQL view that the front end form is linked to, I added the new fields to the forms and when I attempt to...

Hi, I have got an Access03 frontend with an Oracle9-DB as backend. Somehow I cannot edit some (and no special!) records in my table Alle_Personen. Access...

I tried the following to add new record: 1)use query 2)use recordset to add record, then assign value to the field by field At the end, Access always pop up a...

I have a database to which I just added a timestamp field. The update query I'm using uses an ID number from the form used to edit data as criteria and is...

I am trying to write either an expression or criteria to omit rows if it either doesn't contain data or along a few characters.

i have couple hundred thousands records in Access 2007; here is a sample: Account# Time of Call Reason for Calling 1 ...

I'm tracking occurances of clocking-in late, and unexcused absences in Access 2002. My data resides in two tables tblTardy and tblMissedShift. I'm trying to...

I set up the field in table to memo and tried entering a lot of information but when I open the report that field does not expand to show all of the entries....

Hi everyone! I'm from the UK and have always been told when dealing with dates in access wrap the date with # and put the date in the American...

Anyone know how to format a cross-tab query's column headings so the text wraps around instead of going long on one line? Thanks! Ari Blum

Is it possible to wrap the text in a cell in a query, in access 2007? If so, how is it done? Thanks, Divindy

I have a fairly long SQL string that I'd like to wrap since I can't fit in a single line. I'm not sure how to do it, any help would be greatly...

I am creating my first database. I read through some postings and I THINK a nested query would fix this problem but I'm not sure ... and, if it IS the fix, I...

1. I open a form using records from a parameter query. Is there a way to get a drop down menu of choices for the responses in the parameter? Ex: Query has...

I would like access to list the values between that range. Those are the only two pieces of info I have 000001 and 007893

WORLDS LARGEST COMMUNITY !! BE THE PART OF IT ! http://www.agloco.com/r/BBCC5087

Hi, I need to understand and why we get the message saying "Workstation # is locking the table". We have five people using one database and working...

I find that when I go into MS Access Help (that is access help NOT excel) I find listings for Worksheet Functions. One is Today(). In access it doesn't work....