wizard

Is there a way I can convert the letter A to 13 and B to 15 number won’t be in order with the letter. need to be able to type a word and for it to spit out a very long number. For example if I was to type hello need a number 22 23 26 26 35. its for an old alarm panel I need to program and it...

Hello, I have a wonky .txt file. I have to import the data into excel and I use data import wizard. Column B and C have data in there that should be split out into different fields (ie, anothercolumnthing, trans id, anothercolumn, event-time). However, I cannot get the data to be delimited...

Hello, I have a wonky .txt file. I have to import the data into excel and I use data import wizard. Column B and C have data in there that should be split out into different fields (ie, anothercolumnthing, trans id, anothercolumn, event-time). However, I cannot get the data to be delimited...

I can't run a Query using the the Query Wizard in my profile on my laptop, which i was doing regularly before. It just opens Msquery in the background and just freezes. If i log in using a different profile on the same laptop it works perfectly Any ideas on how to resolve without re creating...

Can anyone help me with the answer to this question? when using the Microsoft query wizard what feature is used to designate the rows to include in a query? source selector data filer data validator row selector limited query I had a feeling it was row selector or source selector but I've...

Hello, What I'm looking for is a way to suppress the Analysis Services Connection wizard from popping up if a user inputs an incorrect variable for a OLEDB connection. Basically I have 3 variables. Server, cube and user. I build the connection and then prior to using it, I test it by using...

I would like to set up a Standard Notes wizard for our drafters. For my example, we make three different types of drawings: Assembly, Welding, and Sheet Metal. I would set up a table with notes in the rows and drawing types in the headers. <tbody> NOTE ASSY WELD SHTMTL INTERPRET DRAWING PER...

I have a form and the conditional formatting does not work consistently. It’s a columnar form with tabs within it. It was created from a wizard originally and then heavily modified (both the layout of the form and also the underlying query created by the wizard) When I open the form, the CF...

Hi, I used the Microsoft Query to access data from an access DB that I maintain. when I import it, I view the data in the Wizard tool and it has the correct data but once I close out of it, the data that is imported into the Excel (in table form) is not right. Particularly any columns that have...

At work I had Access 2016, but do to some compatibility issues with my other Microsoft Office programs that were 2013, IT uninstalled all my Microsoft Office. They reloaded Microsoft Office 2013 with Access. So now all my Microsoft Office is 2013. Since they did this, I have two issues. The...

=LOOKUP(Wizard!B4,{"Annually","Monthly","Hourly";annual cost, monthly cost, hourly cost}) This is the formula I am using. The front page has two drop down menus. One with the number of users, and one that is the time frame (above). The goal is to be able to select the number of users, and the...

Is it possible to create an wizard to fill in a form created in excel like a step by step that only specific cells are filled

I have 5 digit and 5+4 = 9 digit zip codes in Excel. Some start with 0 such as 01122. Using the mail merge wizard, the zip codes that begin with zero are getting dropped, which is not what I want. I dont want it to convert a zip from 01122 to 1122, because a zip code should include the...

I am running a VBA wizard, and part way through I HIDE the form to allow the users to modify some items directly in one of the worksheets. After this is done, I SHOW the form, but all the information has reset. Series of events: 1. Run the form SetupWizard 2. Information is entered in a...