Search results

Hi all I am stuck in a quagmire. I need to move the database off to a external server which has Mysql on it. The database is built up with a lot of forms and queries on it. I have not seen an easy way to export my tables to mysql. The more worriesome issue is that will everything break if I...

Hi All I am doing a 3 column lookup wizard for my table in the form . [Data from table] [Group Value] [lookup Value] When I am finished it shows the Group Value. I want it to show the lookup Value. Any Ideas? Thanks in advance.

Hi I need to bind and unbind combo boxes in a form any ideas how to do that?

Hi all Below is a sub procedure firing on the click event on a button on a split form. It does filter the right amount of records. the problem is when the results are show in the split form. Only the fields I filtered are shown. Anyway I can fix it so when I filter the table all the fields are...

Hi I was doing some searching on the web as well as here looking for a way to turn the split form into a search form. Essentially i would like to have the splitform filter the results on the bottom. I do not want to bid it to a query or something as I want to retain the ability to edit the...

Is this possible I wanna have it so my crosstab is always full even if it has dummy data in it

I have a from that drives a number of queries before displaying a report with crosstab query data. I got that working The problem is I was testing this out using the largest data set ie the report is holding the worse case senario with a lot of data. When I select criteria which is only a...

Hi all I have a macro running a sequence of append and delete query and i get like 10 alerts through the whole process which is annoying. Anyway I can have Access not show these and turn them off. Any help much appreciated

Hi All I am having a problem with this form driven query I have set up. My intension is ot have a search form that sits over a table. Users can enter in what infomration it knows into combo boxes. The information will be used to launch a query. Seems simple and I set it up. the problem is that...

Hi All I am trying to create an input form that will be used to populate a main table holding a bunch of info. my current DB structure is to have a main table with some financial data with addtional tables that kind of translate the stuff to more unstandable format (EX 4402-01 = creative...

Hi all Ran into a brick wall with the following cross tab query. TRANSFORM Sum([Top 5 Unpaid by Month].[AMT]) AS SumOfAMT SELECT [Top 5 Unpaid by Month].[VENDOR_NAME], [Top 5 Unpaid by Month].[INVOICE_NUM], [Top 5 Unpaid by Month].[INVOICE_DATE] FROM [Top 5 Unpaid by Month], MonthConv GROUP...