Search results for query: *

I am using VB in a macro to follow a click on a hyperlink, and then copy a single field and paste it back to the spreadsheet. I have over 900 rows and have to do this weekly. I started a Macro with the VB in it. I just can't get it to repeat for all the lines in the range. Column A is the...

Afternoon everyone, was hoping to get some help on something. I have a spreadsheet that we have to update manually on a daily basis. Column A is a hyperlink to the active record on the web. Column D is the order number. The extract is incorrect everyda and they can notfind out why. What we are...

Im very lost here. I am trying to create a link using an entry in a form to show a web page based on that entry. Here's how it is suppose to work. When I click on a particular field (circuit id), it is suppose to use that value and open a page that I have the IP for, then enter it in the search...

Im very lost here. I am trying to create a link using an entry in a form to show a web page based on that entry. Here's how it is suppose to work. When I click on a particular field, it is to copy that value and open a page that I have the IP for, then enter it in the search field and perform...

Is there a way to set up criteria in a query that will locate duplicates of records based on 2 fields using the 1st 6 characters in both fields to find the match with? Like I have 2 fields, one Aloc the other Zloc, between the 2 there are several that show the same 1st 6 characters. How can the...

I have 2 columns, A is the raw data and B is the additional character I need to merge it with into column C. A- E.123456 B- .C C- E.123456.C Problem is when the macro gets to this point I get a Run time error 1004 Paste method of Worksheet class class failed this is the code area that comes up...

Morning, I have my query that I am using to extract data from one table and trying to get it to update to another table. The table I am trying to update to is update, the field is objectcode. The query that extracted the data has the result as myval. The query does pull up and lists the results...

I am trying to work the mid function in the query. I have a column that has a list of text entries. The entries look like this: E.123456.c, but with many different sets of numbers. I am trying to run the mid function like this: Mid([Object],3,6) Object being the title of the field, 3 being 3...

Is there a way to display users currently logged into a DB? It is secured, and all have user names, but not sure how to get all users logged into a db to show up. This would be to gather names for kicking people out of the DB for updates and db maintenance that I would either send a novell pop...

Is there a macro or something that can be created to log out all users when updates need to be made, instead of chasing them down individually?

I have 3 fields called A-CLLI, Z-CLLI and vacants. I have them grouped and am counting the number of vacancies, is there a way to get all of the matching A's and Z's to be grouped into 1 count of vacants? say for example: under A-CLLI I have with multiple entries: BASNMOU0030 Under Z-CLLI I have...

I have a query that lists the date of activity on a record, what I am looking for is is it possible to show on the query result multiple dates? For example: I have a DS-1 system with 24 channels on it. I have it set to record by macro the date of occupancy to a date field. I have that date field...

I have a form and a macro set up to update the date in another field once it becomes checked to show it as occupied. It is set up as an after update event macro with set value to date() That works fine, my problem now is if the item is vacant and the check is removed, how can I get the date to...

Is there a way to have the column titles on my report appear on each page? I'm guessing its pretty obvious, but I am missing it. I need the titles to carry over to each printed page. Anyone know what I am missing?? Any help to point out my ignorance would be greatly appreciated %-)

Can the field names (The names over the boxes) do they have to be at a 90 degree or can the some how be shown at a 45 degree? I am trying to make a column style report with the names going at a 45 degree angle to combine more titles on a page. If I am confusing I apologize. This is current...

I have created a query that uses the circuit ID as the trigger to show what channels are vacant. I created a macro that will launch the query and display the results. This does work, but the only problem is that it never closes. The only way it closes is if you close the leading window...

Morning, I have a code set here that will enable me to send a doc by way of email and prompts users for format and then brings up the email all automatic. Is there anyway I can get it to populate with the send to and all they have to do is hit send? Can this be referenced back to a macro? I can...

in my database I have records that may be in several lines. I have a delete query that can remove it, but I am trying to get it to an update query that will prompt me for the data to put in it's place on all of the occurances. I have a search field to locate all of the occurances of the specific...

Morning folks, I have a multi line entry form in datasheet view. The firsty record I enter goes in smooth, if I have to add another line for more material I get the above error. I have checked a couple different databases and I can not duplicate the error and I don't see what is limiting it...

Hi there. I have created a subform that allows me to add multi line material lists for orders. I have placed the below text field in the footer of the form. When I point it to sum the extendedprice field it kicks back #error =Sum([extendedprice]) My extendedprice is setup with the following...