Search results

I have a custom menu bar that has a couple of menu lists, with a list of five custom commands that i want to run,depending on what is selected.I know you can assign a macro to each command,but is there a way to know which command has been selected. What i want to do is to have 1 macro that will...

Is it possible to delete a table from a remote access db. i.e table "A" is in database "A" from a form in database "B" i would like to run a routine that would Delete table "A" from database "A" i have tried using "DoCmd.DeleteObject acTable" but i think this only works for the...

Is it possible to retrieve the x an y co ordinates of a text box in relation to the client screen. I am trying to align a pop up form so that it doesnt obscure data. i have a main form with 8 subforms.The text box that i want to align with is in each subform,and i use a mouse move event on the...

I am trying to work out an angle in a triangle(non Right angle).Does anybody know how you multiply a number by Cos to the power of -1.Does access have any functions for mutliplying numbers to the power of x thanks in advance Bjackson

I am running a public sub procedure(named SetSearchColumnDetails) that resides in a subform (control name of SearchResults) on a mainform named Searchform.This procedure on my machine runs quite ok,but on another pc access give me an error complaining that the object either is not open or does...

I need to change a registry setting for a 3rd party software program, but i need to do this from within access.The key value is a string expression. I have never atempted to change regisrty settings using vba, could anyone please point me in the right direction Thanks in advance Bjackson

I am trying to edit data in a table that has 30 fields.The fields names are W1,W2,- up to W30, and their value would correspond to a control on a form I have declared the controls in an array, so i would really like to use some sort of loop Is There any way to use a loop to refer to fields to...

I am using the not in the list event to add the new value to a table.I dont want to ask the user whether to add the new item to a list, i just want it to be added.This all works fine except when the value entered is a number less than 1.Access adds the value but then prompts with the usual "the...

I am linking to a database that stores data from a VB application.This application uses the first 6 Characters of a Brand and colour as the unique id for the material. I am just curious to know Why this application wouldnt use an autonumber.When you look at the data its a mish mash of names...

i am trying to set up a db for purchasing laminates but cant get my head around the right way to structure the tables. Each order would consist of 1. selecting a supplier 2.selecting a brand of laminate from that supplier 3.selecting a colour from that brand 4.selecting a finish for that colour...

I have a form where the user has to select a date then select a time for a specific task to be done.I want to store this value in 1 date/time field in a table, but am having trouble joining the two values together to form a valid date. The date TxtBox on the form has its format set as long...

I am trying to update 4 fields in a table using a update query but cant seem to get it right.I keep getting an error message "missing operator in the expression 8:17:PM" or if i leave the TimeStr out of the update the date saved in DateStr is 30/12/1899 Dim TimeStr Dim DateStr As Date...

Is there any way to automate adding an attatchment to emails in access,similiar to to sendobject action.The attatcment is a .Txt file and i need to use Outlook Express not "OutLook". Can anybody help Regards Bjackson

Is it possible to requery a form on one pc from another pc connected on the network at the moment the user has to click a refresh button to refresh the screen with up to date data.If a user on another machine makes changes is there any automation that would update all pcs that are on the network...

could anyone please tell me what criteria to use in a query that would return all order dates that were made today, when the table holding the dates is date/time format i am trying to find any orders that were placed to day regardless of what time they were placed.i tried using date() but that...

i am trying to open a file to which has some cnc machine data in it,but cant seem to crack why or what i am doing wrong i need to open this file and search for data that confirms that the machine has actually performed its task. i have 2 questions 1.what is the most efficient way to search...

i have tried every thing to get this query to work. there must be a simple answer.If i use # to enclose the dates the query returns no record.if i dont use the # the query returns all records regardless of the date Set TopQdf = Dbs.CreateQueryDef("", "SELECT TOP 14...