Search results

Okay you wan to filter the Form based on a ComboBox selection. In that case the CombobBox needs to be Unbound. The next information you need is a Filter on the Form, simply. If Me.Combo25 = "alle erledigen im jänner" Then Me.Filter = "Month([erledigt am]) = 1" Me.FilterOn = True End If

In simple English, could you please explain what you want to do?

Can a file be created with special characters like *, /, \? I would imaging the file name is invalid.

Could you replace the double spaces with a single space? Replace(postCode, " ", " ")

Under properties you should have the option Text Align

What identifies the ID? PO Number to me sounds like the Order number and not the ID that dictates which location the file has to be saved to. Explain in simple English what you want to do.

As MarkK, has suggested mimic the format. where the category look up the ID from the form.

It is a good option, provided you do not over use DLookup, they are normally nasty little things. Used sparingly they work wonders. Good luck !

The three types of JOINS supported by Access are LEFT, RIGHT and INNER. Sometimes (very rarely) all three JOINS could come into action. Which means there is something wrong with your Table structure. Or too many tables on the JOINS, so try and remove a few tables.

I hate to break it to you Jason, but your Tables are not in the right structure. I would suggest you to have a look at http://www.databaseanswers.org/data_models/library_of_film_tapes/index.htm and http://stackoverflow.com/questions/490464/how-to-design-a-movie-database Make a small change to...

Good Luck :)

So you say you have a table (pdfFolder) like, ID | folderPath ---+------------ 1 | C:\Temp\ 2 | D:\Test\ 3 | E:\Sales\ With your DLookup, the value in varFolder should be "D:\Temp\". If the answer is 'Yes', then what is your problem? If the answer is 'No', what is your problem?

If your Query/Rowsource to the comboBox is something like SELECT tableName.FieldName1, tableName.FieldName2 FROM tableName; You can change it as, SELECT tableName.FieldName1 As MeaningfulHeading1, tableName.FieldName2 As MeaningfulHeading2 FROM tableName;

Hi Jason, Welcome to AWF :) Hope you find the site interesting and learn something new.

You can also use a Query to Open the Recordset and loop through. Using a Query can also make it very simple terms of getting the right data. With your description it is not sure what you need. You can post pics before you reach the post limit, as long as you ZIP them and add to your reply.

Hello Ciaran89, Welcome to AWF :) What I would suggest you is to create a RecordSet object and then loop through it. Something like, Dim rsObj As DAO.RecordSet Set rsObj = Me.RecordsetClone Do While NOT rsObj.EOF .FormFields("FirstName").Result =...

SELECT @@IDENTITY is a statement that returns the ID of the newly inserted record it does not need FROM or WHERE clauses to it. How to Upload a Stripped DB. To create a Sample DB (to be uploaded for other users to examine); please follow the steps.. 1. Create a backup of the file, before you...

Which line is that error being raised? Did you make sure you have created a button called "buttonName" or any other name and made sure that you changed it to the name of your button? Also that the text box named as Mobile_Phone? Please adapt the code to your design matches.

Well the INSERT statement TJ has shown is just a skeleton, you should be aware the structure of the INSERT statement. INSERT INTO <yourTableName> (<fieldName1>, <fieldName2>, ..... <fieldNameN>) VALUES (<Value1>, <Value2>, ..... <ValueN>) The bits in fancy colours is what you...

Well this is what I would do, create an unbound form that has nothing but one text box control and one button. The text box is where you will enter the Number. On click of the button you will check your Table and see if you have the record entered, if so open the Client Form (bound to the Client...