Search results

It is not actual name of table row. I just used that name to describe the code. Form also has apropriate name. Just thought it would be easier to understand the code, without using actual names of forms, controls...

Unfortunately, advices from provided link do not help. My OS is Win7 starter. Office is 2010 starter. Access is 2010 full retail version.

For example, I have a List box containing dates of data input. When I choose a date, form diplays all inputs from that date. ListBox_AfterUpdate() Me![textBox1] = Me!ListBox Me.Filter = "Date = Forms![Form_Name]![textBox1]" Me.FilterOn = True Code was working for years and it still works...

I just swithed from Office 2003 to Office 2010 and my forms work funny now. Every time I want to update record on a form, based on control selection, I have to hit refresh button. I know I could solve problem with me.refresh, but I have a lot of places to put that command. Why is this...

Made it :) Right click on the task bar > properties > Taskbar buttons > chose: never combine, or combine when task bar is full. I can see my app. icons now. :):):)

Yes, I have a form that opens automaticaly. No, I am not using the shift key to, when I start app. Why is your task bar so different to mine? Icons on my taskbar all square, while yours is wide.

I am using single icon file. When you tested, did you see application icon in the taskbar? I'we attached image that may help us avoid possible missunderstanding. If I place a mouse on top of Access aplication, I receive wide stripe with application icon and other text information. What I want...

Mr. B, Thank you for your reply. I did that, even clicked "Use as Form and Report Icon" check box. The icon I want is in top left corner of my Forms and reports, but access icon is still present on the task bar. I am using Win7 starter. Also, Office 2010 is starter version as well. Only...

How to change access icon to application icon in the task bar in office 2010? I was using office 2003 before and, when application icon was set in start up, it was automatialy visible in the task bar. Tks!!!

I didn't ralize that it is a function :o Thank you, it works now.

Thank you for your message, but I am not familiar with commands used in the suggested posts. Is there other way arround it? I almoust found the solution on the post: http://www.access-programmers.co.uk/forums/showthread.php?p=959714 I tried that and it works exactly as I want if form field...

Thank you for the prompt reply. I don't need to filter the form data. I have a form field that filters List Box on the form. The List Box is a list of customers and according to the form field's string, list of customers on the List Box is filtered. Now, I want to have a command that will ask...

I want to use Set rst = db.OpenRecordset("query_name") to open a query but the query has a parameter which is a form field. Parameter must not be fixed. I have to use Like command, to filter all data containg the string from form field. Thanks!

... and what if I need to filter a record that contains a string from control on the form but does not match entirely. Like if the control contains "Lon", command shuld filter all data containg "Lon", like "London", "Londoner", "long"... How is this possible in VBA? I managed this in query using...

It also happens with number data types. I can use all text data types. Also, if I combine data or number data with text data, I have no problem. Not sure if this is normal behavior for query. Exactly that is strange to me. It happens automatically. All new queries I am trying to make...

Hi! I think my queries started to act strange. First problem is when I select several fields from a table and then go to SQL, it always has a comma and a * at the end of the first row. For example: SELECT Id, FieldX, FieldY, * FROM... Normally it should be: SELECT Id, FieldX, FieldY...

I hope I sent it now

... having trouble to send file

Thank you for very quick response! I found a sample for what I want to do and I just can't make it work. Do you know why is this SQL working in sample and not working in my case?

Hi! I need to add ordinal numbers (I hope I am using apropriate word, I need to have a row where numbers will go in sequence from 1 to as many as there is data), to this query. This code returns #Error in column RB. What am I doing wrong? Thanks!!! SELECT [Izlaz roba].ID, [Izlaz...