Search results

Less or more I understand what you mean , but have no idea how to implement this. Could you please help with this sample? Thanks

I have excel file with two fields: Website column is a function: =+HYPERLINK("http://www."&A3&".com","Press..") When importing to Access , the link is disappeared. How to keep the 'Website' field value, based on 'Model' (as in Excel)?

I have a range of board serial numbers, starting from SN0000001 and till SN0001000. How can I create automatically 1000 records, what the VBA code to do that?

You're right, it's text. I tried to to make CInt(...), but it doesn't help. Is any way to change it to Number, if I alredy have tables with relations?

Increment field by one is not working I have some code: Private Sub SamplesReceived_Click() Dim SLFIDUpdate As String ' avoiding "Write Conflict Error" Me.Dirty = False ' open modal form with a current record DoCmd.OpenForm "SamplesReceived", , , "[SamplesID]=" &...

sorry for my ignorant, could you explain technically how I do that?

Hello guys, As I understood from MSDN, new Access does not table protections. If I have a database for 10 users, how can I limit using forms only and to avoid users access to tables?

I am building a database for cars ordering. Please advise how to solve , with one table or two tables following issue: I need to order cars , and when the car is receiving to update relevant record.

Please find below event of "check box click" Private Sub CarPurchased_Click() On Error GoTo CarPurchased_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("Would you like to update new cars?", vbQuestion + vbYesNo, "Cars Purchased") If intAnswer =...

Can you explain it in easie language..? Sorry for my nescience

When I checking the checkbox will be opened modal form where in the fields will be values of current record. Could you help with a code ?

How I can in Access 2007 lock with password all tables and forms, and to leave only one form for use.

This in not a table , this is a form in datasheet view.

I want to write some code when I'm checking "Purchased (Y/N)" field then opening existing form with filled fields. It must be something like: Private Sub Purchased_(Y/N)_Click() ... DoCmd.OpenForm ... End Sub

Thank you , pbaldy! I learned something new..

I have two forms: "New City" and "City Form". "City Form" has a combobox for City selection, which bound to table "Cities". The user is selecting a value from combo box. When the value does not exist, I wish to add "New City" button, that will open "New City" form. After filling this form I will...

Yes, sure, why not.

Hi wiklendt, I attacked the problem from another side. I added bookmarks in my *doc file, and pointed to those bookmarks from Access code. Example: Set objRange = doc.Goto(What:=wdGoToBookmark, Name:="bkmSamples") objRange.InsertAfter (Samples_ID.Value) Regards..

I'm not sure that this helps, I actually need to avoid typing in combobox. In C# this style calls 'Dropdownlist'.

How can I turn Combobox to Dropdownlist , it means "to disable" typing in combobox?