Microsoft Access / VBA Forum

I have a database built in Access that is on our Windows Server. We have a satellite office in Houston that uses Citrix to access our server. Here in the main office, we have 15 users that log directly into the LAN; there are 4 users that dial in via Citrix. We have constant errors in our Home office that someone has locked up the...

Dad, Nope, never heard of 'Tartiflette'. I suppose it shouldn't be a surprise that there is a French version of Raclette. The website is strange isn't it? On the one hand it is a demonstration of simple self-drive web authoring and on the other hand it has some excellent looking recipes. Maybe a husband and wife team is behind it? Date...

hi access guru's there is a requirement wherein i have to connect ms access frontend with sybase (backend). the data from the frontend should be saved in the table in sybase databae thro rational suite of tools. any hints, pointers regarding the above situation would be veri helpful. thanx, have a great week ahead

Hi, Is it possible for fields in a table to have an effect on the results of a query which does not directly use those fields? To explain, I use this query Select * from addresses where address4 in (select country from countries) This shows all results where address4 is also in the country table, but only

Hi all, I am generating a report that adds one of two images (or no image at all) depending on query results. I dont want a great big blank space where the image goes, if NO IMAGE is returned..... Any way I can do this? I know I cannot use 'can grow' as I do with text boxes. any help appreciated. andy

Hi all I have been given a corrupt access 2000 backend and asked to salvage the data.(youve gussed it, no backup) On trying to open it just kicks me out saying its not a valid database file - so I can't even use the internal compact/repair function I have tried the usal stuff i.e. Trying to repair via another access program using dao

Hi there, I have been frustrated by the 'next record' problem when a user tabs off the last control on a form. I have tried a couple of the suggestions listed on the newsgroup, but so far nothing has solved the problem in relation to my database. I have 3 subforms on the form and serveral other controls (such as buttons). When the...

I have a number of Acess databases on a web site and copies of these databases on my local PC. The databases can be independently updated on the web and also on my local PC. Is there some way of synchronising my local copies of the dbs with the ones on my web site? I had thought this would be a common problem but I can't seem to find a...

Hello, Although a lot of postings in the past discuss the subject of A2000 and Unicode support, I couldn't find what I was looking for. My institute is compiling a dictionary of early middle dutch. The sources used for this dictionary contain a lot of very specific characters. Many of them are not available in current font sets, so we made...

Hello all, I was hoping someone might know where, if at all, you can download the Additional Wizards for MS Access 2000 (VB Help, Converting Macros to VBA, etc.) and Excel 2000. I didn't install them when I originally installed Access and Excel and have misplaced the CD-ROM. Any help with this would be appreciated. regards and thanks...

I have some old code locked in two Access 97 files where I lost the mdw file and the pid do to system crashes. Can someone refer me to a commercial vendor who can crack these files? - Regards - Kurt

Hi, Can anyone help me with some vb code as i have little or no know of this programming language. I have a SQL server containing my datatbase and using an Access front end. I have two table: CONSUMABLES, TASKS Both these tables contain CONSUMABLE_ID. They both also contain STATUS (regards the consumable status, in use, dead, stock...

Hi I wish to create a synchronized database to give to each of our 150 travelling sales reps. They would fill out forms on their laptops, on the move, and then when they dial up (56k) at the end of the day to get their email, they would synchronize the database. Sounds ok? Well I would like also to be able to sychronize changes to...

What would be the best approach in populating all report headers with the same secondary name, i.e., ABC Company? Manually typing in the same name as a label on 40 different reports is not an option. Thanks for your advice. Dalan

Hi All, I have a List Box on a form. The values in the list box need to be variable based on another field value (text box) on the form. How can this be done. Each time I try, the values are set once (when the form is opened) and not reset when the value of the text box changes. Thanks!!! Paula

Hi, When are string fields null, and when are they empty? For example, if the record has never been edited, is it null? If the record has been edited but deleted, is it an empty string? I'm not sure whether to use: x is not null or

Hello, I'm a new user designing a simple database to retrieve pre-prepared docunents for printing. I have five tables, a form to design the documents, a form to customise and retrieve the documents, a query to pull the data together from the tables and a report which formats the document with the custom data ready to print. It works...

Hi, Using make table/select distinct, I managed to remove many duplicates from a table. However, there still appears to be many duplicates left when looking at the table. Every field matches, so why aren't these being picked up? Thanks, Chris

Hi, Hoping someone can help. I have created a pivot table and launch it via a command button. Unfortunately, it opens in form view and not in pivot table view. I have opened the form in design view and set the default view to pivot table but still no luck. I have searched Google but no help there either. Any help/advice appreciated. --

Hello all, In a split database environment, is it safe to still use the following?: set db = CurrentDB or must one be more explicit and indicate the path and name of the database being initialized? Also, how safe is it to have different operating systems accessing the

I have about 7000 student records of college entrance exam records. i want to build a form where I can select a range of scores in a combobox and return a list of students with scores in the selected range. The ranges will be <600, 600-700, 701-800,801-900,901-1000, 1001-1100,1101-1200,>1200. I need some help on how to get the selected range...

I am trying to send information to 2 different MS Word 2000 documents from automation code in Access 2000. I have simply added an extra transfer text command and an extra line to open the document with the data text file for the merge data. What is happening is that only the 2nd of the two letters is opened. Why doesn't the first one open? ...

I need help with a function to be used as the criteria for a query. The field in the query is InventoryStatus: - . The function is built around a Select Case set of about twelve cases. Function MyCriteria() Select Case Forms!MyForm!MyCbx Case 1 My Criteria = "<0" Case 2 MyCriteria = "0"

How do I write the conditional If statement for a query criteria where if Forms!MyForm!MyCbx = "AllCategories" then Like "*" else Forms!MyForm!MyCbx ? I can't get the Like "*" to work. Thanks! Steve

I am desiging an invoicing program that will do recurring billing as well as charging for any additional service at a given time. All charges will be service oriented. I am particularly concerned with being able to seperate uninvoiced charges and invoiced charges and would appreciate advice on do's or dont's, or any Ideas for a better way to...