Search results

Thank you cpberg1 for advising the issue with the trust center. How did you get a textbox to display a value like "#######"? I know this from Excel. But Access? There is no need to add VBA for custom ribbons. Menu bars from Access 2003 can be used in the 2010 version as well.

Let me see if I understand your scenario right. You migrate to the 2010 version on the server but not on the clients? - And, in general, why do you use Access on a server instead of a SQL Server backend (or MySQL or DBASE or Oracle or...)?? How many users connect to the backend? However, as...

Can you upload an empty copy ( = empty tables) of your accdb file please?

Sorry to leave you this way. No idea at the moment. Will come back if new ones come up.

Append once or twice? What I mean is, do you have added a File tab entry in your custom ribbon definition? If so, would it be o.k. to remove that one?

So this system table is "USysRibbons", right? Check your ribbon definition there for a double entry. If found, remove it.

How did you made your custom ribbon? Do you have some XML code somewhere? If so, did you check it?

Surely not exactly what you are looking for... but just a suggestion. From my point of view you should put as much as possible into "tblSailingProcessPassanger" and not in 11 separate tables.

You are welcome! As you noticed, the error was caused by the 'is' in front of the > sign. With this solution you bind the user to that texbox, that is, he can't leave it before he has entered a correct value. Not very user friendly. In respect to that you should do it as suggested by Pat. Put...

Do it this way: Private Sub Index_Date_BeforeUpdate(Cancel As Integer) If IsNull(Index_Date.Value) Then Exit Sub End If If DateValue(Me.Index_Date) > Date Or DateValue(Me.Index_Date) < Date - 14 Then MsgBox "Index Date entered is invalid.", vbExclamation...

Unfortunate! - Hope that other forum members can help you with their ideas. :o

That's what I thought. - Having >30 users you should consider to migrate to the (free) MS SQL Server Express edition.

What kind of backend do you use? An accdb (or mdb) file?

Why do you want to update the locked? Let the users do this when they open their form (or start working on the job). Then they should run an update query which sets the value of the field "LOCKED" to 'True'.

If you have your query stored as an object in your database, you can do it like this (assuming the Excel file is located in the database directory): DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "NameOfYourQuery", CurrentProject.Path & "\YourExcelFile.xlsx" Note that this...

You are "not sure what information is needed" but seem to have a precise idea in your mind. Please explain.

Access 2007 and 2010 have the same file format so it should work. For use with the 2003 version I've attached a converted file.

You cannot create endless forms. If you put some controls on it you have to know where the border is. Access assumes a user who has Tabbed Documents enabled don't want to change the page size in form view (otherwise he would not have selected this mode). In this case you should work with a non...

This is strange. Do you get any error message (when you try to delete)? "...every user has said...". Did you check that by your own eyes?

Hi aldeb, you'll find attached my approach to your task. If you create a form to select the player names and to display the desired result, you should use a combobox with two columns. The first one with the ID and width = 0 (that is invisible). The second one with the names and with the width...