I didnt read it but would this work?

http://www.kitebird.com/articles/access-migrate.html

and here's another
http://www.howtodothings.com/computers/a3744-how-to-convert-access-to-mysql.html

What is the field size for the number fields in the table?

Check out this post for Question A. It seems similar. http://www.daniweb.com/forums/thread224378.html

Question B I'm not sure.

This is for school work isn't it?

One way would be to have the store number entered from a combo box.

Have a table of all your store numbers, locations, etc. Make a combo box based off that table and add in all the fields that...

I'm sure there is a VBA approach to this, but you could also make a macro with 6 lines in it.

Make a new Macro and use the following:

SetWarnings = No
OpenTable = table you want to remove all...

Check out this little sample I just made. Is this what you are trying to do?

Also, if you are creating the expression, then the table field should be left blank. The query will not add this data...

Is your field called HomeSum or HouseSum? You have it written both ways in your question. Try it without putting [ or ] around your constant.

I'm pretty sure Access says it can handle up to 255 concurrent users, but I personally would not trust that.

I have made databases in which 5 - 6 people used it at the same time and it handled...

The simplest solution would be to use Microsoft FrontPage. You can create a form in it, and tell it to link to a database. FrontPage will make the database and set up all the necessary connections. ...

gmalsack do you want to just have the name display that way, or do you want the names to be entered into your database permanently after typeing them in like that.

If you want to just have them...

Found a solution that works. I should have figured it would be easy.

IIf(IsNull([forms]![frmFilter]![DeptCombo]),[Department],[forms]![frmFilter]![DeptCombo])


I put this as a criteria for...

If anyone can point me in the right direction I would greatly appreciate it.

I am making an Asset Management database. I'm looking at having about 50 fields in a table. Of those 50, 25 could...

If you can't get timothy's suggestion to work, type null rather then "" in your condition.

So again I'm not a programmer, but here is the finished product after searching through a lot of websites. It works so if anyone is ever trying to take Word form data and import it via Access, use...

I'll start off saying I am not a programmer. I am making a database that imports data from Word forms. It requires code and I found some that works almost perfectly for me at...

I have a database used for Phone record auditing. I am trying to see whether it is possible to have labels within a section disappear for 1 page but appear for another. I'll explain below.

In the...

Or put this in the criteria of your query

Between [Enter Start Date] And [Enter End Date]

It will prompt for the dates.

If you want it to always be set dates, type

Between #M/D/YY# AND...

Well just because I couldn't wait for a reply, I decided to remake the report copying the controls from the broken one. It works fine now.

I have a really weird thing happening in my database. It used to work fine but all of a sudden now when I preview the report, it shows up too large. Please see the pictures to understand what I mean....

Like this?

Access is a very unforgiving app in that when working with tables, you only get 1 undo (with the exception of deleting because once its gone, it's gone).

You could try to do a restore, but usually...

I am unsure atm whether having the field be set as a number would cause the problem. Why not set the SSN to be a text field with an SSN input mask?

What determines whether the SSN is valid or not?...

The iif function has 3 parts (condition, true, and false). Your condition is SSN=50. If your condition is true, it will display 99, if the condition is false it will put in the SSN. This is based...

How exactly do you want to separate the data. When it is in Excel, do you want to have a blank line separating the grouped values or do you just want the amounts sorted in an ascending order?

Charts don't filter data. Charts graphically display data. You need to filter the data before making the chart. So essentially you need to use possible either Advanced filter or auto filter within...

What exactly do you want to filter? The data in Excel or Access?

I guess I am confused because whenever I have made forms with subforms, the form fields in the subform are always visible regardless of whether data is present or not. Is it possible for you put put...

For the sub forms, Do you want the fields to change based off the PlaceID? or will all the fields be the same? Do you have your subform showing in form view or datasheet view?

Just ask, not sure if I can help, but I'll try.

Long integer which is the default for number data type, while it will show 2 decimal places if you set it , it cannot actually read them.

In the table you should be looking at either currency or number. The field size should be either decimal, single or double.

What data type and field size do you have set in the table? Keep in Mind that some of the field sizes don't allow decimals.

Does the data in your table have 2 decimal places, or did you just set the query and report to display at 2 decimals?

You do that in either a query or a report.

You might want to consider 365.25. Keep in mind that every four years there is an extra day :)

I have a list box set to simple multi select option. I want to be able to pass those options to a text box. If I have multi select set to no, the value appears in the textbox fine. Whether I set it...