Search results

Hi! Is your dabase is back-end split database? if so then re-link your tables and try to compact & repair your front end application:

Hi guys! I have invalid password issue with MakeTable Query Statement in (linked database) on the Network. I have created a MakeTable query which inserts records based on the criteria and creates a table in a linked database on the network drive. This was working fine in Access 2007 and earlier...

Hi Jarik Welcome to AWF, did you try CrossTab Queries in Ms-Access?? A crosstab query is a matrix, where the column headings come from the values in a field.

you can alias the query fields by prefixing the field name with the alias and ':' (colon) in the query grid or QBE for example MyLongFieldName to: MyField: MyLongFieldName But the question is why you want to rename the tables field to something else, if you do so, then your are messing up with...

What's the freaking bone :rolleyes:

Glad to see that you got a help and clue :)

Command38 is already clicked then what to decide if it is clicked???

Did you normalised your tables properly i.e the relationships between the tables has the PK and FK? What Query u are using to get the result so far? Your Query should be somthing like this: SELECT COUNT(*) FROM ships INNER JOIN classes on ship.id=class.shipID INNER JOIN battle ON ship.id...

You should re-query your form 1 after you have added the new record using form 2.

Hi Big_Pat If the form's record source is the table where the field 'ActivationDate' comes from, then it will save the current date automatically to the underlying table in the 'ActivationDate' field when you close the form or goto another record either by record navigation buttons or some...

If you don't want to show your field to your users then you can hide it on the form. In design view of the form, you can goto the format property of the field/control and set it to Visible Yes/No. You also can directly put your generated id to your desire table by inserting it through INSERT...

David! If your form has the underline table (the DataSource of the form) is directly your table/query, then you can refer your generated id directly to that field. Me.YourFieldOnTherForm.Value = strCalcSurveyID

Glad that it works for your :) actually in VBA Me. is the current object/field on the form: If you are in the VBA section of a form and want to refer to a control on that form then the quickest most efficient way of achieving a connection to this control would be the most direct Me.ControlName...

Welcome to AWF! you can add the generated ID to the control/Field on the form: with your code add this line in your code:

I think you should put dot(.) before and after the .AND. and also the brackets after the WHERE clause ( )

Welcome to the AWF! It is easy to display the number of 3 decimals points on currency or number fields. Do the following: 1- Goto the form where your currency field is shown. 2- Right click on the form to open it in design window. 3- On the right side of the form a property window will appear...

As explained by Mr. B, Access Database should be provided to the end user in Front-End MDE or ACCDE Format where they can put the data in a database through Forms. The Back-End (tables) should be kept separate from the end user and should be password protected. Here is how to convert Access...

100% bob :) I was with my friends to have fun with Barbie queues; and the smiley you put it it here is very cute.

I miss the cross TWIPs of replies :p coz I was away :)

What is the different between the following lines: If Forms![Bid - Vendor Quotes]![Bid - Quote]!optShowOpening = -1 Then 'Open full report AND this one: Else If Forms![Bid - Vendor Quotes]![Bid - Quote]!optShowOpening = -1 Then 'Hide Mfr, Show Opening These seem to be same...