Microsoft Access / VBA Forum

hi I work with access on reg.comp. and at home on laptop I save the data on USB. ext.hard dr. and or cd. DVD of course rewritable my ques. is some times data is being lost while working around is there something I"m

Hello Partner, Please forward some good resumes with excellent communication skills. ATG Dynamo Developer Location: Minneapolis, MN Duration: Long-term Startdate: ASAP.

Hey All, I wrote this code in SQL View Query window but when I try to save it, I get an error box that says "Syntax Error in FROM clause" I've tried a few different variations in the syntax but still to no avail. Hopefully someone can look this over and tell me what I'm doing wrong, thanks in advance. (Using Access 2003 by the way) ...

Is it possible to get a query in the form of a listbox to be able to look up valves on a form. ie It is possible to get a listbox to find records on a form by selecting a field form the listbox

Larry Linson you're correct. I was using the wrong terminology. I meant that the field in my form would search one table, then another, until it was found. In my particular situation, I deal with employee ID numbers. I have one table that includes active employees and another that has inactive employees. Right now I open up two...

I have set up an access database with a switchboard to multiple forms, reports, etc. I have gotten comflicting information about whether or not staff throughout my facility will be able to view the information simultaneously. I have been told if it is set up properly it will be possible, but I am wondering how to set it up so this is...

I'm wondering how many different users on different workstations can open the same ade file residing on a server. Is there a limit and how would I trap any errors? Thanks lq

The back end is on a server. Compact on close is set on, but on the clients server isn't happening, though no errors are being generated. On my machine here Compact On Close happens fine. Is this an NT permissions thing? Cheers, Mike

Could somebody please tell me if it is possible, and if so how, to place a command button on a form so that when it is clicked a black line will be placed through all the clients information (name, address, DoB, etc) on that form. Thus notifying others that that person is deceased. Many thanks for any help you can provide Stu

Hi: I need some help writing code that will "print" a report using Cute FTP. Specifically, I need to set up a "Button" which, when clicked, will: a. Create an FTP "Print" file of the report using Cute FTP. The file needs to be given a unique name based on data that will be in the report and on the query that generates the report.

Hello, I've had help from this group before and I hope someone could be of help again. I have 2 tables as follows tbl_joinings Mnum JoinDate

hi I work with access on reg.comp. and at home on laptop I save the data on USB. ext.hard dr. and or cd. DVD of course rewritable my ques. is some times data is being lost while working around is there something I"m not saving it correctly 2) I compacted one file it went from (225) mb to (217) mb did i loose data 3) what does compacting...

hi whats the different methods in saving a database i'm alternathing between laptop& desktop and external hard drive.losing data here and there. will "briefcase" help me and or shall i upgrate to ms. sql server currently i'm working with ms.access 2003 any suggestions alex

I am creating an application that will need to share data, to exist on a company's intranet, and to be used by 50+ users. The sharing consists of only added data. Each user will be able to see, but not change, data entered by one of the other users. The transaction volume is probably 500 added records per month per user. Does this seem like...

I have an mdb application sitting on my PC that is linked to tables in another mdb database on a server (other people use my application to access this common data). I have setup the relationships on the mdb table database (on the server). Do I also have to set up the same relationships on my mdb application sitting on my PC, or is the...

I want to allow users to resize and reposition columns of a datasheet but for a prompt to be brought up and only the layout only to be saved if they select "save changes". This is the way it works at the moment for queries but for datasheet forms I find that it automatically saves column positions and widths without prompting to save changes.

I have a query with an output field that has criterium . When I run the query and I enter for instance "3" (without the quotes) I get all records with category 3. However when I enter "1 or 3" (without the quotes) I get no resulting records. When I replace in the query with "1 or 3" (without the quotes) it gives me what I want, records with...

I had to get a new computer this week and I have been running Paradox for the last 6 years, now I have to use Access 2007. Now forgive me if this question has been asked a million times hence but here goes. Can I open or transfer data from my Paradox tables to Access 2007? If so any help would be greatly appreciated. Thanks Ed

Dear reader, If "Compact on close" is set to yes (tickbox) the mdb or mde will be compact by closing. During this process a temporary db1.mdb will be generated and deleted after the compact is finished.

I have two fields on a form. These two fields' values are based on an expression and represent a date range. I need to create a SQL statement that will use the returned values of these two fields in the WHERE clause as a date range (less than or equal to, and greater than or equal to the upper and lower dates of the range). I then need to...

Hi all. I have to import a CSV file (made by the user with Excel) into an A97 table. This is the code I use in my ASP page (NT4.0 Server/IIS4): sql = "INSERT INTO ImportTable SELECT * FROM ." It works, but I have a little problem that is driving me crazy: one of the fields is a phone number and I'm unable to preserve the leading zero.

Hi everyone Is there someone out there who can tell me how to create relationships between tables using VB??? PS I am using MS ACCESS 2003 and I have read the help... THANK YOU

I've developed an interoffice system that has 2 generic interfaces; user and supervisor. What I'd like to happen is to have the user interface open directly to an input form (easily done) and have the supervisor interface open directly to a report (not so easy from what I've seen). I've created 2 separate front-end dbs for each so for the...

Hello all, On running this code below I get the errmsg: Too few parameters. Expected : 1 is an existing field in a linked table. Can anybody see what I do wrong here? Many thanks Ronny Dim dbsMyCheckBase As Database Dim rst2 As DAO.Recordset

I have a table (tblVendorSpend) which has 3 fields (VendorID, Spend, Top250) I import this table monthly from another database. What I need to do is update the Top250 field (yes/no) if the vendor is in the Top 250 by spend. How can I achieve this?