Search results

So first it finds a row with canada, deletes that entire row and then the 4 following rows, so 5 rows total. Is there a way to loop the code you gave? Thank you guys for the help I am still working with the code : ) you guys gave me Thank you : ) : ):) Is there a way to loop your code...

I have a problem where I was given a list of companies in an excel sheet that are formatted horribly. 3727 Memento Funeral Chapel Mailing: 5201 Lakeshore Drive Business Unit: Canada Physical: 5201 Lakeshore Drive Bonnyville, AB T9N 1X7 Managing Dir: John Gordon Bonnyville, AB T9N 1X7...

This is what I have of course Rows(rng.Row + #).Delete is not real code, its just a place holder to show what I need. If anyone knows the code to tell vba to delete the following 4 rows please assist : ) I also have another excel vba question, I will post in another thread. Thank you...

I haven't seen a lot of information about the xml datatype that now has support with sql 2005. I want to be able to have users make selected text bold ect. from a command button so they don't have to type in the xml tags manually because to them typing <b> memo text </b> is "hard" ;) hahah I...

in access 2007 you can create a button to do this using the wizard : )

found it :) advanced section under access options! w00t Behavior entering field The options in this section change the behavior of the ENTER, TAB, and arrow keys when you use them to move the cursor from field to field in forms and datasheets. Select entire field Selects the entire field...

I was wondering if there was a setting in Access 2007 where you can make it so when you tab through fields on a form or use your mouse to select a text field on a form that the cursor will go automatically to the end of the last character. Access 2007's default is highlight or select the...

Yes they posted some code, thanks for the update :) I get automatic updates from here default, but I always forget to click the updates on UA. Code is goood :) haha thank you

Sounds like a plan, I don't know anything about the subject you are talking about. I will research it, If you feel like shedding a little more light on the subject that would be appreciated :) Thank you for your response !

I have a timeclock that I built into my access program. That just allows employees to clockin and out. I needed to ask how to automatically through VBA when a form is closed from a click of the [X] in the upper right hand corner how to cancel the changes that are waiting to be updated in the...

I am a programmer that recently was assigned the task of building a single network site with 2 servers. The servers are both supposed to take on the role of the root domain and thier own Active Directories and are to use DHCP. Though the companies are considered separate there are 2 people that...

I will research this, I am not familar with it. I will get back with you, Thank you

First off thank you for your response :) Our timeclocks are completely different : ) I will say it more simple what I have, I know I am confusing :confused: There are 2 tables: Employees ; TimeClock There is 1 form for clockin and a seperate for clockout: ClockIn consists of - 1 combobox...

I have a timeclock form, that allows people to clock in and out. The recordsource for that form is a table. I want to have the form check the table to see if someone has already clocked in, so they don't clockin twice without clocking out. There will have to be some sort of code/query that...

Does anyone else have this happen to them, or, is this just a problem local to me? HELP :X

Or if there was a different field type that would still allow you to enter different lines of data within the same field?

yes lots of them hahah. what tables are you using, I am guessing you have a quiery? if you have so many tables?? on one report. this is my first suggestion, build a query that puts all your information into one table that you need for that form/report. use the query as the source and then just...

I am not sure if this is only an access 2007 problem, or if its maybe a problem on the server side of this, I have a sql back-end on the server. If I enter data into a memo field access 2007 does this weird thing where it drops the last word to a new line. ie. ---Entry 1: Hi my name is Harley...

If you have the information stored in a table you should def bind your text box to the field in the table ; ) just make your record source the table and then add the field to the report. But no, I didn't get anywhere on this : ) If there was a way, I'm sure someone here would of shared...

Thats the thing though! I don't want to store these notes. I want to on the fly in report view just type it in. Then print : ) record1 quick note record2 quick note i don't want the quick note to be stored in the db possible?