Search results for query: *

Hi All, I am trying to copy/transfer tables from one database to another BUT doing it from a master database. For example, the Master database has a button that when clicked will copy/transfer tables from database-A to database-B (so 3 databases in total) I have searched for awhile and cannot...

Hi All, Maybe someone can assist me in trying to get this code to work? I have half of it working but not the month end part. What I need: When launching the database or if it is already loaded and you show all records and it is a Friday then show the message in a popup box saying "Please Run...

Good Day All ! I have an excel question and not sure how to get it to work properly. I have tried both VLookup and Index but can't seem to get it to work. To give a brief description of whats going on here is a break down of what I am trying to do: Sheet 1: Column A Column B Column C...

Hello All -- I need some assistance if possible. I am needing help with a password form I have. I have a table named PasswordTable with a single password in it and a password form named AdminForm. On the form I have an unbound text box named PasswordTextBox , a close button and a Submit button...

Hi All -- I am kind of stuck on a combobox. What I have are 2 tables which are joined by badge_number and then I have a sign-in and sign-out field. On the form I have a combobox that displays a list of badge numbers that are supposed to be available but I keep showing all of them. I built a...

Good Day! I was wondering if someone could assist me in a query to swap data in the same table. Basically I have one table "Inv1" that houses records of floor information and computer information. So lets say I have a record to where its serial number is 12345 and it is in column "Serial#"...

I have 2 table that mirror one another so all the fields are the same. Table Inv1 and Table Inv2 A form with a sub form showing like a split pulling data from both tables. Main form showing Inv1 and subform pulling data fromInv2. What I am wanting to do is have a button that runs vb code that...

Hello All, I was wondering if this would be possible to have in a database. What I have is a quantity field for inventory and a reorder level; what I want to happen is automatically email me if any given item is equal to or less than the reorder level. The trick, I would guess, is to make it...

Ok, I am need of help since I had to ditch a recent wanna be solution. I have 2 tables Main and Tech_Directory...What I need to happen is on the form once the data is filled out and hit the submit button I need it to check and see if [Tech_Number] on the form (which is pulled/stored on the main...

Hello -- How do I add the text field(s) from the access form to the bottom of the list (1st row without data in it) for the 4 columns in the excel file if it isn't present on the lookup? I know it goes under the spot "ELSE ... 'did not find the value " but I don't know what the coding is...

Hello all, I was wondering if someone could assist me in creating a command button in access to when it is clicked it will open and search an excel file (column A) based on textbox1 on access form, if found it will change the cell 3 over to the right in the excel document (column d but on the...

Hello, Maybe someone can assist me in getting this script to work. What I want this to do is when ran it will read a list of computers from a text file "computers.txt" and invoke/run a file from a shared location and install it on those machines listed in the text file. $cred = get-credential...

Hello all.... I have a report which has 5 subreports inside of the report. The problem is that they all work but I have to click in each field of each subreport to show the data. Is there a onload or on current event I can use to make it so when I launch the main reprot all subreports populate...

Hello All -- Sorry to be a pain but I am in need of some assistance on a weird request: I have a form that has a unbound text field showing the current user logged in the computer utilizing the fosUserName() Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA"...

Hello All, I have a situation to which I don't know the best way to do this, can someone please assist me in doing the following. I have a search that when you search for a spcific item it displays the record in another form named: frmSearch_Results. Which works fine. Now here is the tricky...

Hello, I have a form that is pulled from a query and shows the results on the form properly. On this form I have a button that sends an email to a recipient with the results from the query/form however the problem is it is only showing one of the records in the email body and not the reminaing...

Hi All, I am not sure how to tackle this porblem I am having. What I want to do is make it where I have a form with a list of certain records with Name, Phone Number and employee number that is pulled from a query. The query part is working properly but what I want do on the form is show the...

Hello, I know this will probably be really basic but how can I accomplish this please? I have a button on a form that when clicked it will reveal a hidden label or text box and store that information for that record (saying something like "Confirmed" Thanks for your help... btw I am using...

Hello, I was wondering if someone could assist me in creating some code that when I click on a Button on the form the it will utilize an Event Procedure to where it creates a new record but copying over data of like 4 fields from the previous record automatically. Any help is appreciated...

I am writing a script to pull all the users who has a homedirectory on a certain server using a wild card. It runs and no errors but it exports nothing and doesn't run long. Any assistance would be appreciated: $csvfile = "C:\Scripts\Home-Dir-Lookup.csv" Get-QADUser -SizeLimit 0 -SearchRoot...