Microsoft Access / VBA Forum

Is there any way to create a query similar to the old CASE statement in FoxPro?

Is there a quick way to simultaneously set the properties of ALL Access toolbars the same, e.g. set it to: - "No Horizontal", - deselect "Allow Moving", - etc.? For example, is there an ascii file, something like an .ini file that I can quicly edit and set everything the way I want?

Hello, In an application of mine I make an export to an exceltemplate. In this template is a graph which is based on the range GRAPHRANGE (i've named it in Excel like this). When I make an export I want to modify this range, so that the graph is based on the correct data. Has anyone any suggestions on how to do this from code?

Hola de nuevo a todos... Agradecido a todos los que me habeis solucionado problemas anteriores... Pero como no es novedad, me surge otro. Recientemente buscando, adquiri un codigo para juntar 3 ficheros de texto. El cual adapte para el desarrollo de mi DB. El proceso es genial, pues junto los tres ficheros pulsando solo un boton. (O...

Hi I am trying to implement a 'browse' feature where a file dialog is opened and it returns the single file name that the user selects in the dialog. Can I see a code example of it somewhere? Thanks Regards

I two tables one of real estate properties and the other is a table of tenants. The Tenants table has a PropertyIndex field which ties the tenants to the propertys. I have a query that lists the properties and its tenants but it cannot be used for a report because it doesn't know what to do with the additional fields when there are more...

I have spent the past few weeks designing a database for my company. The problem is I have started running into what I believe are stack overflow problems. There are two tab controls on the form (nested), three list views, one tree control with up to 30,000 nodes, maybe 15 comboboxes (half of which have a large recordset as rowsource), 20 or...

If I wanted to be able to copy all of the tables in an existing database called Original.mde to another database called New.mde from a button click event in Original.mde, is there an easy way of coding it without naming every single table in Original.mde. I am looking for a way of updating a database on site without needing to access the...

Would appreciate any help on this: I have an A2K frontend/backend application developed & tested on client's "usual" server. Then moved both back and front ends to a different server so application could be used by folks in another department. Weird behavior: When we put the back-end on the different server, then we can't do a...

I'm trying to put together a simple access database that will allow a friend to maintain a simple database of products/pictures/prices, which he can then export to html and upload to a website. Problem is that access doesn't export the images when saving to HTML :( The export to PDF solution isn't appropriate in this instance, is their a...

Hi NG! I just managed copying data from one table to another table (boah, what a big deal :). But there are still some problems: 1) I want to use the keyword "BETWEEN" in combination with date fields in my SELECT statement, but Execute does not like it. I tried different variations, none of them works :(

Hi I've been trying to create an addin similar to Find & Replace from Rick Fisher that looks thru your tables / queries / forms / modules etc.. for a reference to a string and optionally let's you replace it. In order to get this to work I need to get - the tablenames and columnnames - the queries in plaintext - the properties of a form...

Hi, I'm using the ConvertCurrencyToEnglish module readily available on the internet to convert some currency figures to text. However, I want the code do one additional thing and I'm not sure how to go about it. I want the data field to fill a particular size of space on my form, and I want the area that does not include text from the...

Can a textbox on a form be referenced as the criteria for a field in a crosstab query? When I use an expression like Forms!PFrmCriteria!Criteria, an error message appears saying Access can not recognize 'Forms!PFrmCriteria!Criteria' as a field or expression. However, if I put in the actual value of the criteria in the crosstab query, the query...

Does anyone have more info about the Yahoo API using the SOAP system to automate searches via access ? or even the google API services, which are limited to a mere 1000 searches per 24 hours with no idea of when or if this limitation will ever move up to 100,000 per day. How can I implement this for a beginner into some sort of module or...

This is probably a frequent question, but I can't find the answer anywhere. I'm developing a search page for a form, and since the results change with each keypress, I need to allow spaces (ie the keyword "joe bloggs" would go "j", "jo", "joe", "joe ", "joe b" etc.). Access automatically trims the space off the end, though. Is there an...

I have a form which is based on a table (a) with over 6000 records.I have a button on this form which will open another form with related data from another table (b). What I want to do is open the second form and see the related data or if it hasnt got any related data create a new record in table (b) so that I can input data. If possible I...

dear respected sir, i would like to ask you following problem to anyone can give me hints - i have database of insurance company, where policy table is link to customer table and each policy has details policy table - now the pk in poicy table is policyno(pk) - so every year the same client policy came for renewal, so v need to design...

dear sir can any one help me that how to get the value or any strings type in input box to update the value of a bound form...the text box on bound form name is policyno or any other example that can help me in order to understand hereunder scenerio rgds, shahzad

Hi all, I want to be able to uncheck all the options in the start-up menu so that along with the workgroup information, all the menu's are removed making the database even more secure. The problem with that is that I will not be able to re-instate the menus to do changes should I need to. (Will I?) With this in mind, is there any way I can...

I have a situation with a query that is formed by linking a whole lot of 2 column 'sub' queries to a 'main' query using left joins. The main query is a list of ID's and the sub queries all contain a specific piece of information related to each id. So by linking them all together I can get the full picture by ID -in theory. The problem I...

Can someone help me with this logic Iff "Current Quarter =1 then "Past Quarter=4 Or If "Curent Quarter" = 2 Then "Past Quarter =1...and so on. I can find previous quarter base on my current quarter by using the following lines of code. I don't know how the next coding for second quarter. SELECT tblSchedule.Adate, tblSchedule.Lot,...

Hi all, I have 2 tables, times & dates times includes amongst others, 2 fields, date in & day dates includes date & day. I have set the lookup property (combo box) on . to SELECT DISTINCT dates.day FROM dates WHERE (((times.=dates.date))); This works fine for the first record I fill in but on the next record, it remembers the previous...

Hello all, I have a table which has 30 memofields each containing a text. (Approx. 1/2 page). Depending on various situations these texts are sent via e-mail. When the time comes to send text nr 24 it won't send and Visual Basic gives me this warning : Runtime error '6' 554 5.7.1. Command rejected. When clicking on help it says something...

Anyone written any code to work with the CommandBar object? I have a custom menubar, with 6 buttons, and up to 3 levels of nested menus, such as: File File | Print (that's 2 levels)