Search results

I am trying to do something very simple but for some reason I can not get this to work. I have a linked .csv table: (s:\pctools\admin\template\sadirect\SellerFeesReport.CSV) and I am using query 'dupSellerFeesReport' that does a simple group by to get rid of all duplicate accounts (if they...

Hello all. I am in need of some intelligent brains =) I have a barcode scanner (Videx LaserLite DuraTrax) that I am using to scan the barcode of all the mail we receive. I am attempting to come up with a common characteristic between each mail company (DHL, Fedex, UPS, USPS) that would allow me...

Can someone help me figure out how to make this work. I am wanting for each page I make to import my CSS file. My current code: <link type="text/css" rel="stylesheet" href="layout.css"> this works with every page that is located in the root directory with the CSS file present there. What I...

I have the below code which works great. I would like to make an addition to this code where it will pull up all of the accounts if no date is entered into the startdate/enddate text boxes. I know I need to add the * somewhere, but not sure where. Thanks in advance. DoCmd.OpenReport...

Can anyone help me out I am trying to create a command button (cmdBrowse) that pops open a file dialogue to select a file. I am not sure how to do this, does anyone know? If you need more of an explaination. I am trying to create a form for a user to be able to select the document needed to be...

I searched these forums but I did not see anything that was helpful in the matter, so if there is a thread like this please direct me to it and disregard this. I have a combo box that houses the names of dealerships, this is bound to a table. A user does have the ability to add a new...

I am trying to come up with a good, clean and efficient way to solve a problem of mine. I have my main form that has a combo box that allows an associate to put a set of information in (a name) and then once they type it in, to hit a command button that pops up a second form for the contact...

This is either going to fall under the query section or the report section but since this pertains to my report I figured I would start here. I have my main_tbl that is setup with a relationship on the field AccountType with tbl_AccountType, so it will display the name rather than a number in...

I have a question regarding union queries, for the most part I understand them. You have to have the same amount of fields in both tables/queries, but what I do not know is do both tables/queries need to mimic each other 100%. For example I have 2 Queries, both match each other identically in...

I am not sure if this is even possible, and I am almost positive it is going to resort me to have to figure this out in VB but I am wanting to create a table of contents that also includes the page number. I want the number to automatically update to the correct page in case if it changes. Is...

I am trying to brainstorm and idea that I have to better improve my companies database security. Right now all we have is a passworded backend and user levels for each person who uses the database. 10 - default; 50 - supervisor; 100 - developer. I am wanting to create a function, that looks...

SELECT UCase(Users.UserName) AS Associate, Count(Users.UserName) AS Pending, Sum(IIf(Date()-[DateNotified]<16,1,0)) AS [0-15 Days], Sum(IIf(Date()-[DateNotified]>15 And Date()-[DateNotified]<31,1,0)) AS [16-30 Days], Sum(IIf(Date()-[DateNotified]>30 And Date()-[DateNotified]<46,1,0)) AS [31-45...

This is probably more easier than my brain is allowing it to be. I have 2 queries AccountsClosedToday_qry SELECT UCase(Users.UserName) AS Associate, Count(Information_tbl.IsActive) AS [Closed Today] FROM Information_tbl INNER JOIN Users ON Information_tbl.Associate = Users.UserID GROUP BY...

I am having a minor headache with a situation, I have a command button that opens a view of the report that will be printed. The problem is if someone creates a new record and hits the button it comes up blank. If I add me.requery before the DoCmd statement then it just restarts to the very...

What is the CSS code that needs to be used in order to get rid of the bttom scroll bar. I only want it showing when the window is too small, right now it shows regardless of window size. I am sure it's a margin thing but I am still learning and I am unsure, thanks ahead of time.

I am creating an intranet site and would really like to use a custom icon near the URL bar or a Favicon. The only problem is that I have tried <link rel="Shortcut Icon" href="S:\Common\Website\Images\favicon.ico" /> and I have gotten no results, is this possible with an intranet? Is there an...

I can not for the life of me figure out how to make my website scale to a resolution on its own. What I mean a normal website would stay regardless if you adjust the browser or a resolution. What I am lookin for is like what this forum does if you alter your browser to make it slimmer, how it...

I know this is probably extremely difficult but regardless it was requested. I am needing to know how to have a custom toolbar/menubar (not sure which it is) with my mouse when it is right-clicked. Any information/help would be extremely appreciated. PS: I did use the search but I did not find...

I am having an issue with my combo box filter, this set of code dynamically updates the combo box to add any new user and select the accounts that are assigned to them. Given everything works and everything filters, the problem is merely a cosmetic one that has to be fixed. Basically what is...

I have created a module that will enable a custom menubar if it meets the specified requirements. The only problem I have right now is I can not get rid of the standard menu bar. My code I am using is below: Public Function CmdBars() 'This Function will allow for a custom menu bar to be...