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...

The lookup fields in the table is instrumental to my input form whats a resonable alternative

its not on a form its on the table itself so I cannot go into the properties at all

ok is there any way I can alter the lookup wizard to change the column number once it is set up? In the wizard I do not think they give me an option of specifying this.

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.

Thanks a bunch I finally got my form working right now. The problem was I unbound everything to prevent acidental editing so when I filters the non filtered data was not hooked up to anything

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...

OK I am trying to use this technique and its not quite working right. I have unbound the combo boxes on my split form and added the filtering code as lsited. The problem is it is not showing the rest of the infor in the table. It comes back blank rather than with info. Thouhgi t is...

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

so basically use the info in the link to pull zeros for stuff it does not find? Edit OK this may need to be put in a different place I have a query that generates data for the cross tab. Do I need to force it to have data for all the columns so everone is represented. Is there a way...

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...

On the money Brian this is fantastic between the two I have what I need. Thanks a bunch case

Hey vbaInet can you clarify your last statement on your way of implementing a warning blocker not sure I know what you are talking about

OK I see the code and that works nicely, MY only question is can I stack the code so duplcate it like 3 or 4 times and each be limiting the results. This would be sitting on an acounting DB where a vendor may appear multiple time. The link shows a great way to handel the vendor search but I...

thanks I got it!!!!

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...

ok one last question any reason why i am getting a syntax error on this TRANSFORM Max("$" & [Top 5 Unpaid by Month]![AMT] & " " & [Top 5 Unpaid by Month]![VENDOR_NAME] & " " & [Top 5 Unpaid by Month]![INVOICE_NUM]) AS ITEM SELECT (SELECT Count([Top 5 Unpaid by Month]![Display Month]) As...